Home | Forums | Contact | Search | Syndication  
 
 [login] [create account]   Friday, November 22, 2024 
 
slxdeveloper.com Community Forums  
   
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
 Administration Forums - Database Administration
Forum to discuss SQL Server or Oracle database administration related to SalesLogix databases. View the code of conduct for posting guidelines.
Forums RSS Feed


 Back to Forum List | Back to Database Administration | New ThreadView:  Search:  
 Author  Thread: Reserved DB words
Rick Smith
Posts: 96
 
Reserved DB wordsYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 15 Mar 06 2:01 PM

buy abortion pill online reviews

buy abortion pill
Greetings SLX comrades,
Wondering if anyone has a handy link to reserved words in db field names?
I just encountered one: Organization How many more are lurking out there?
Thanks,
Rick Smith
[Reply][Quote]
Ryan Farley
Posts: 2265
slxdeveloper.com Site Administrator
Top 10 forum poster: 2265 posts
 
Re: Reserved DB wordsYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 15 Mar 06 2:13 PM
That would be great to have. I've not seen such as list, but I would imagine that it is comprised of reserved words from Interbase, MSSQL, Oracle, plus some that are very SLX specific.

For the SLX specific ones, there are many which are not so much as "reserved", but more for special purposes. For example, adding a field called SECCODEID to a table will allow you to control security to that data (and sync). Some field names in previous versions would cause unexpected results and it would mess the joins up (like adding a field named ADDRESSID in pre-6.2 versions).

I hope someone does have a complete list. I would love to see it too.

-Ryan
[Reply][Quote]
Timmus Agersea
Posts: 328
 
Re: Reserved DB wordsYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 15 Mar 06 2:22 PM

viagra online

viagra 50 mg go
SQL Server:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ra-rz_9oj7.asp

Oracle:
http://www.cse.unsw.edu.au/~oracle/Oracle8_doc/DOC/server.804/a58234/vol2_wor.htm

I tried finding the info on Oracle's site as I prefer using vendor documentation but I could not find anything.

Timmus
[Reply][Quote]
Rick Smith
Posts: 96
 
Re: Reserved DB wordsYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 15 Mar 06 2:37 PM

buy citalopram 20 mg online uk

buy citalopram 20 mg online uk
Timmus - thanks for the links. This is very helpful.

The particular word I encountered - "Organization" - isn't in the MS list (I'm using SQL Server 2000).
The SLX DB Manager would not let me create a field with this name.

So there must be another list that SLX itself reserves...
[Reply][Quote]
Timmus Agersea
Posts: 328
 
Re: Reserved DB wordsYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 15 Mar 06 2:41 PM

lexapro pregnancy test

lexapro pregnancy risk category open
Happy to help, Rick. As Ryan stated it is a combination of Oracle and SQL reserved words that SalesLogix must enforce as they are "database agnostic". Organization is a reserved word in Oracle.

If there is a list that the SalesLogix team has embedded in the application it would be very nice if they dumped it out as a reference. I'll ping them and see if they will do so.

Timmus
[Reply][Quote]
Rick Smith
Posts: 96
 
Re: Reserved DB wordsYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 15 Mar 06 2:44 PM

naltrexone low dose

naltrexone redirect
Oh, yes, I should have checked the Oracle list...doh!
[Reply][Quote]
Bob (RJ)Ledger
Posts: 1103
Top 10 forum poster: 1103 posts
 
Re: Reserved DB wordsYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 17 Mar 06 10:12 AM

vermox

vermox online
Here's a copy of an "olde but goodie" list of reserved words right out of an old SalesLogix Document:

SYMBOLS ­- ! & ( ) * , . / : @ [ ] ^ + < = >

A - ABSOLUTE, ACCESS, ACCOUNT, ACTION, ACTIVATE, ACTIVE, ADD, ADMIN, ADVISE, AFTER, ALL, ALL_ROWS, ALLOCATE, ALTER, ANALYZE, AND, ANY, ARCHIVE, ARCHIVELOG, ARE, ARRAY, ARRAYLEN, AS, ASC, ASCENDING, ASSERTION, AT, AUDIT, AUTHENTICATED, AUTHORIZATION, AUTO, AUTODDL, AUTOEXTEND, AUTOINC, AUTOMATIC, AVG

B - BACKUP, BASED, BASENAME, BASE_NAME, BECOME, BEFORE, BEGIN, BETWEEN, BFILE, BITMAP, BLOB, BLOBEDIT, BODY, BOOLEAN, BOTH, BREAK, BROWSE, BUFFER, BULKBLOCK, BY, BYTES

C - CACHE, CACHE_INSTANCES, CANCEL, CASCADE, CASCADED, CASE, CAST, CATALOG, CFILE, CHAINED, CHANGE, CHAR, CHAR_CS, CHAR_LENGTH, CHARACTER, CHARACTER_LENGTH, CHECK, CHECK_POINT_LEN, CHECK_POINT_LENGTH, CHECKPOINT, CHOOSE, CHUNK, CLEAR, CLOB, CLONE, CLOSE, CLOSE_CACHED_OPEN_CURSORS, CLUSTER, CLUSTERED, COALESCE, COBOL, COLLATE, COLLATION, COLUMN, COLUMNS, COMMENT, COMMIT, COMMITTED, COMPATIBILITY, COMPILE, COMPILETIME, COMPLETE, COMPOSITE_LIMIT, COMPRESS, COMPUTE, COMPUTED, CONDITIONAL, CONFIRM, CONNECT, CONNECT_TIME, CONNECTION, CONSTRAINT, CONSTRAINTS, CONTAINING, CONTAINS, CONTAINSTABLE, CONTENTS, CONTINUE, CONTROLFILE, CONTROLROW, CONVERT, CORRESPONDING, COST, COUNT, CPU_PER_CALL, CPU_PER_SESSION, CREATE, CROSS, CSTRING, CURRENT, CURRENT_DATE, CURRENT_SCHEMA, CURRENT_TIME, CURRENT_TIMESTAMP, CURRENT_USER, CURSOR, CYCLE

D - DANGLING, DATABASE, DATAFILE, DATAFILES, DATAOBJNO, DATE, DATETIME, DAY, DBA, DB_KEY, DBCC, DEALLOCATE, DEBUG, DEC, DECIMAL, DECLARE, DEFAULT, DEFERRABLE, DEFERRED, DEGREE, DELETE, DENY, DEREF, DESC, DESCENDING, DESCRIBE, DESCRIPTOR, DIAGNOSTICS, DIRECTORY, DISABLE, DISCONNECT, DISK, DISMOUNT, DISPLAY, DISTINCT, DISTRIBUTED, DML, DO, DOMAIN, DOUBLE, DROP, DUMMY, DUMP

E - EACH, ECHO, EDIT, ELSE, ENABLE, END, END_EXEC, ENFORCE, ENTRY, ENTRY_POINT, ERRLVL, ERROREXIT, ESCAPE, ESTIMATE, EVENT, EVENTS, EXCEPT, EXCEPTION, EXCEPTIONS, EXCHANGE, EXCLUDING, EXCLUSIVE, EXEC, EXECUTE, EXISTS, EXIT, EXPIRE, EXPIREDATE, EXPLAIN, EXTENT, EXTENTS, EXTERN, EXTERNAL, EXTERNALLY, EXTRACT

F - FAILED_LOGIN_ATTEMPTS, FALSE, FAST, FETCH, FIELD, FILE, FILLFACTOR, FILTER, FIRST, FIRST_ROWS, FLAGGER, FLOAT, FLOB, FLOPPY, FLUSH, FOR, FORCE, FOREIGN, FORTRAN, FOUND, FREE_IT, FREELIST, FREELISTS, FREETEXT, FREETEXTTABLE, FROM, FULL, FUNCTION

G - GDSCODE, GEN_ID, GENERATOR, GET, GLOBAL, GLOBAL_NAME, GLOBALLY, GO, GOTO, GRANT, GROUP, GROUP_COMMIT, GROUP_COMMIT_WAIT, GROUP_COMMIT_WAIT_TIME, GROUPS

H - HASH, HASHKEYS, HAVING, HEADER, HEAP, HELP, HOLDLOCK, HOUR

I - DENTIFIED, IDENTITY, IDENTITY_INSERT, IDENTITYCOL, IDGENERATORS, IDLE_TIME, IF, IMMEDIATE, IN, INACTIVE, INCLUDING, INCREMENT, IND_PARTITION, INDEX, INDEXED, INDEXES, INDICATOR, INIT, INITIAL, INITIALLY, INITRANS, INNER, INPUT, INPUT_TYPE, INSERT, INSTANCE, INSTANCES, INSTEAD, INT, INTEGER, INTERMEDIATE, INTERSECT, INTERVAL, INTO, IS, ISOLATION, ISOLATION_LEVEL, ISQL

J - JOIN

K - KEEP, KEY, KILL

L - LABEL, LANGUAGE, LAST, LAYER, LC_MESSAGES, LC_TYPE, LEADING, LEFT, LENGTH, LESS, LEV, LEVEL, LIBRARY, LIKE, LIMIT, LINENO, LINK, LIST, LISTS, LOAD, LOB, LOCAL, LOCK, LOCKED, LOG, LOG_BUF_SIZE, LOG_BUFFER_SIZE, LOGFILE, LOGGING, LOGICAL_READS_PER_CALL, LOGICAL_READS_PER_SESSION, LONG, LOWER

M - MANAGE, MANUAL, MASTER, MATCH, MAX, MAXARCHLOGS, MAXDATAFILES, MAXEXTENTS, MAX_SEGMENT, MAXIMUM, MAXIMUM_SEGMENT, MAXINSTANCES, MAXLOGFILES, MAXLOGHISTORY, MAXLOGMEMBERS, MAXSIZE, MAXTRANS, MAXVALUE, MEMBER, MERGE, MESSAGE, MIN, MINEXTENTS, MINIMUM, MINUS, MINUTE, MINVALUE, MIRROREXIT, MLSLABEL, MODE, MODIFY, MODULE, MODULE_NAME, MONEY, MONTH, MOUNT, MOVE, MTS_DISPATCHERS, MULTISET

N - NAMES, NATIONAL, NATURAL, NCHAR, NCHAR_CS, NCLOB, NEEDED, NESTED, NETWORK, NEW, NEXT, NO, NOARCHIVELOG, NOAUDIT, NOAUTO, NOCACHE, NOCHECK, NOCOMPRESS, NOCYCLE, NOFORCE, NOLOGGING, NOMAXVALUE, NOMINVALUE, NONCLUSTERED, NONE, NOORDER, NOOVERRIDE, NOPARALLEL, NORESETLOGS, NOREVERSE, NORMAL, NOSORT, NOT, NOTFOUND, NOTHING, NOWAIT, NULL, NULLIF, NUM_LOG_BUFFERS, NUM_LOG_BUFS, NUMBER, NUMERIC, NVARCHAR2

O - OBJECT, OBJNO, OBJNO_REUSE, OCTET_LENGTH, OF, OFF, OFFLINE, OFFSETS, OID, OIDINDEX, OLD, ON, ONCE, ONLINE, ONLY, OPCODE, OPEN, OPENDATASOURCE, OPENQUERY, OPENROWSET, OPTIMAL, OPTIMIZER_GOAL, OPTION, OR, ORDER, ORGANIZATION, OUTER, OUTPUT, OUTPUT_TYPE, OVER, OVERFLOW, OVERLAPS, OWN

P - PACKAGE, PACKED, PAD, PAGE, PAGELENGTH, PAGE_SIZE, PAGES, PARALLEL, PARAMETER, PARTIAL, PARTITION, PASSWORD, PASSWORD_GRACE_TIME, PASSWORD_LIFE_TIME, PASSWORD_LOCK_TIME, PASSWORD_REUSE_MAX, PASSWORD_REUSE_TIME, PASSWORD_VERIFY_FUNCTION, PCTFREE, PCTINCREASE, PCTTHRESHOLD, PCTUSED, PCTVERSION, PERCENT, PERM, PERMANENT, PIPE, PLAN, PLI, PLSQL_DEBUG, POSITION, POST_EVENT, POST_TRANSACTION, PRECISION, PREPARE, PRESERVE, PRIMARY, PRINT, PRIOR, PRIVATE, PRIVATE_SGA, PRIVILEGE, PRIVILEGES, PROC, PROCEDURE, PROCESSEXIT, PROFILE, PROTECTED, PUBLIC, PURGE

Q - QUEUE, QUIT, QUOTA

R - RAISERROR, RANGE, RAW, RAW_PARTITIONS, RBA, RDB$DB_KEY, READ, READTEXT, REAL, REBUILD, RECONFIGURE, RECORD_VERSION, RECOVER, RECOVERABLE, RECOVERY, REF, REFERENCES, REFERENCING, REFRESH, RELATIVE, RELEASE, RENAME, REPEATABLE, REPLACE, REPLICATION, RESERV, RESERVING, RESET, RESETLOGS, RESIZE, RESOURCE, RESTORE, RESTRICT, RESTRICTED, RETAIN, RETAINDAYS, RETURN, RETURNING, RETURNING_VALUES, RETURNS, REUSE, REVERSE, REVOKE, RIGHT, ROLE, ROLES, ROLLBACK, ROW, ROWCOUNT, ROWGUIDCOL, ROWID, ROWLABEL, ROWNUM, ROWS, RULE, RUNTIME

S - SAMPLE, SAVE, SAVEPOINT, SB4, SCAN_INSTANCES, SCHEMA, SCN, SCOPE, SD_ALL, SD_INHIBIT, SD_SHOW, SECOND, SECTION, SEG_BLOCK, SEG_FILE, SEGMENT, SELECT, SEQUENCE, SERIALIZABLE, SESSION, SESSION_CACHED_CURSORS, SESSIONS_PER_USER, SESSION_USER, SET, SETUSER, SHADOW, SHARE, SHARED, SHARED_POOL, SHELL, SHOW, SHRINK, SHUTDOWN, SINGULAR, SIZE, SKIP, SKIP_UNUSABLE_INDEXES, SMALLINT, SNAPSHOT, SOME, SORT, SPACE, SPECIFICATION, SPLIT, SQL, SQL_TRACE, SQLBUF, SQLCODE, SQLERROR, SQLSTATE, SQLWARNING, STABILITY, STANDBY, START, STARTING, STARTS, STATEMENT, STATEMENT_ID, STATIC, STATISTICS, STOP, STORAGE, STORE, STRUCTURE, SUB_TYPE, SUBSTRING, SUCCESSFUL, SUM, SWITCH, SYNONYM, SYS_OP_ENFORCE_NOT_NULL$, SYS_OP_NTCIMG$, SYSDATE, SYSDBA, SYSOPER, SYSTEM, SYSTEM_USER

T - TABLE, TABLES, TABLESPACE, TABLESPACE_NO, TABNO, TAPE, TEMP, TEMPORARY, TERMINATOR, TEXTSIZE, THAN, THE, THEN, THREAD, TIME, TIMESTAMP, TIMEZONE_HOUR, TIMEZONE_MINUTE, TO, TOP, TOPLEVEL, TRACE, TRACING, TRAILING, TRAN, TRANSACTION, TRANSITIONAL, TRANSLATE, TRANSLATION, TRIGGER, TRIGGERS, TRIM, TRUE, TRUNCATE, TSEQUAL, TX, TYPE

U - UB2, UBA, UID, UNARCHIVED, UNCOMMITTED, UNDER, UNDO, UNION, UNIQUE, UNKNOWN, UNLIMITED, UNLOCK, UNPACKED, UNRECOVERABLE, UNTIL, UNUSABLE, UNUSED, UPDATABLE, UPDATE, UPDATETEXT, UPPER, USAGE, USE, USER, USING

V - VALIDATE, VALIDATION, VALUE, VALUES, VARCHAR, VARCHAR2, VARIABLE, VARYING, VERSION, VIEW, VOLUME

W - WAIT, WAIT_TIME, WAITFOR, WHEN, WHENEVER, WHERE, WHILE, WITH, WITHOUT, WORK, WRITE, WRITETEXT

X - XID

Y - YEAR

Z - ZONE

[Reply][Quote]
Timmus Agersea
Posts: 328
 
Re: Reserved DB wordsYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 17 Mar 06 10:45 AM

buy amoxicillin from canada

amoxil without prescription click buy amoxicillin online

zoloft and weed

can zoloft and weed kill you website
fiogf49gjkf0d
Nice. Thx Bob.
[Reply][Quote]
Ryan Farley
Posts: 2265
slxdeveloper.com Site Administrator
Top 10 forum poster: 2265 posts
 
Re: Reserved DB wordsYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 17 Mar 06 11:05 AM
Awesome! Thanks RJ!
[Reply][Quote]
 Page 1 of 1 
  You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

   Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
 

 
 slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation.
 This site, and all contents herein, are Copyright © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.

code of conduct | Subscribe to the slxdeveloper.com Latest Article RSS feed
   
 
page cache (param): 11/22/2024 9:59:30 AM