Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

[r6809]: incubator / orxsql / orxsql.cls Maximize Restore History

Download this file

orxsql.cls    710 lines (681 with data), 39.9 kB

  1
  2
  3
  4
  5
  6
  7
  8
  9
 10
 11
 12
 13
 14
 15
 16
 17
 18
 19
 20
 21
 22
 23
 24
 25
 26
 27
 28
 29
 30
 31
 32
 33
 34
 35
 36
 37
 38
 39
 40
 41
 42
 43
 44
 45
 46
 47
 48
 49
 50
 51
 52
 53
 54
 55
 56
 57
 58
 59
 60
 61
 62
 63
 64
 65
 66
 67
 68
 69
 70
 71
 72
 73
 74
 75
 76
 77
 78
 79
 80
 81
 82
 83
 84
 85
 86
 87
 88
 89
 90
 91
 92
 93
 94
 95
 96
 97
 98
 99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
/*----------------------------------------------------------------------------*/
/* */
/* Copyright (c) 2010-2010 Rexx Language Association. All rights reserved. */
/* */
/* This program and the accompanying materials are made available under */
/* the terms of the Common Public License v1.0 which accompanies this */
/* distribution. A copy is also available at the following address: */
/* http://www.ibm.com/developerworks/oss/CPLv1.0.htm */
/* */
/* Redistribution and use in source and binary forms, with or */
/* without modification, are permitted provided that the following */
/* conditions are met: */
/* */
/* Redistributions of source code must retain the above copyright */
/* notice, this list of conditions and the following disclaimer. */
/* Redistributions in binary form must reproduce the above copyright */
/* notice, this list of conditions and the following disclaimer in */
/* the documentation and/or other materials provided with the distribution. */
/* */
/* Neither the name of Rexx Language Association nor the names */
/* of its contributors may be used to endorse or promote products */
/* derived from this software without specific prior written permission. */
/* */
/* THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS */
/* "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT */
/* LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS */
/* FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT */
/* OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, */
/* SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED */
/* TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, */
/* OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY */
/* OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING */
/* NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS */
/* SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. */
/* */
/* Authors; */
/* W. David Ashley <dashley@us.ibm.com> */
/* */
/*----------------------------------------------------------------------------*/
/*----------------------------------------------------------------------------*/
/* Class: CLI */
/*----------------------------------------------------------------------------*/
::class cli public
-- This is a base class to hold all the common constants, attributes and
-- methods use by the subclasses.
::attribute SQLRETURN -- set on return from all methods
::attribute SQLDIAG -- diagnostic array of messages
::method version class EXTERNAL "Library orxsql OrxDB_version"
::method isBitSet class EXTERNAL "Library orxsql OrxDB_isbitset"
-- SQL return codes
::constant SQL_NULL_DATA -1
::constant SQL_DATA_AT_EXEC -2
::constant SQL_SUCCESS 0
::constant SQL_SUCCESS_WITH_INFO 1
::constant SQL_NO_DATA 100
::constant SQL_ERROR -1
::constant SQL_INVALID_HANDLE -2
::constant SQL_STILL_EXECUTING 2
::constant SQL_NEED_DATA 99
-- environment attributes
::constant SQL_ATTR_OUTPUT_NTS 10001 -- probably not needed for ooRexx
-- connection attributes
::constant SQL_ATTR_ACCESS_MODE 101
::constant SQL_ATTR_AUTOCOMMIT 102
::constant SQL_ATTR_LOGIN_TIMEOUT 103
::constant SQL_ATTR_TRACE 104
::constant SQL_ATTR_TRACEFILE 105
::constant SQL_ATTR_TRANSLATE_LIB 106
::constant SQL_ATTR_TRANSLATE_OPTION 107
::constant SQL_ATTR_TXN_ISOLATION 108
::constant SQL_ATTR_CURRENT_CATALOG 109
::constant SQL_ATTR_ODBC_CURSORS 110
::constant SQL_ATTR_QUIET_MODE 111
::constant SQL_ATTR_PACKET_SIZE 112
::constant SQL_ATTR_CONNECTION_TIMEOUT 113
::constant SQL_ATTR_DISCONNECT_BEHAVIOR 114
::constant SQL_ATTR_DRIVER_THREADING 1028
::constant SQL_ATTR_ENLIST_IN_DTC 1207
::constant SQL_ATTR_ENLIST_IN_XA 1208
::constant SQL_ATTR_CONNECTION_DEAD 1209
-- statement attributes
::constant SQL_ATTR_ASYNC_ENABLE 4
::constant SQL_ATTR_CONCURRENCY 7
::constant SQL_ATTR_CURSOR_SCROLLABLE -1
::constant SQL_ATTR_CURSOR_SENSITIVITY -2
::constant SQL_ATTR_CURSOR_TYPE 6
::constant SQL_ATTR_ENABLE_AUTO_IPD 15
::constant SQL_ATTR_KEYSET_SIZE 8
::constant SQL_ATTR_MAX_LENGTH 3
::constant SQL_ATTR_MAX_ROWS 1
::constant SQL_ATTR_METADATA_ID 10014
::constant SQL_ATTR_NOSCAN 2
::constant SQL_ATTR_PARAM_BIND_TYPE 18
::constant SQL_ATTR_PARAMSET_SIZE 22
::constant SQL_ATTR_QUERY_TIMEOUT 0
::constant SQL_ATTR_RETRIEVE_DATA 11
::constant SQL_ATTR_ROW_BIND_TYPE 5
::constant SQL_ATTR_ROW_NUMBER 14
::constant SQL_ATTR_ROW_ARRAY_SIZE 27
::constant SQL_ATTR_SIMULATE_CURSOR 10
::constant SQL_ATTR_USE_BOOKMARKS 12
-- getinfo types
::constant SQL_ACCESSIBLE_PROCEDURES 20
::constant SQL_MAX_DRIVER_CONNECTIONS 0
::constant SQL_MAXIMUM_DRIVER_CONNECTIONS 0
::constant SQL_MAX_CONCURRENT_ACTIVITIES 1
::constant SQL_MAXIMUM_CONCURRENT_ACTIVITIES 1
::constant SQL_DATA_SOURCE_NAME 2
::constant SQL_FETCH_DIRECTION 8
::constant SQL_SERVER_NAME 13
::constant SQL_SEARCH_PATTERN_ESCAPE 14
::constant SQL_DBMS_NAME 17
::constant SQL_DBMS_VER 18
::constant SQL_ACCESSIBLE_TABLES 19
::constant SQL_CURSOR_COMMIT_BEHAVIOR 23
::constant SQL_DATA_SOURCE_READ_ONLY 25
::constant SQL_DEFAULT_TXN_ISOLATION 26
::constant SQL_IDENTIFIER_CASE 28
::constant SQL_IDENTIFIER_QUOTE_CHAR 29
::constant SQL_MAX_COLUMN_NAME_LEN 30
::constant SQL_MAXIMUM_COLUMN_NAME_LENGTH 30
::constant SQL_MAX_CURSOR_NAME_LEN 31
::constant SQL_MAXIMUM_CURSOR_NAME_LENGTH 31
::constant SQL_MAX_SCHEMA_NAME_LEN 32
::constant SQL_MAXIMUM_SCHEMA_NAME_LENGTH 32
::constant SQL_MAX_CATALOG_NAME_LEN 34
::constant SQL_MAXIMUM_CATALOG_NAME_LENGTH 34
::constant SQL_MAX_TABLE_NAME_LEN 35
::constant SQL_SCROLL_CONCURRENCY 43
::constant SQL_TXN_CAPABLE 46
::constant SQL_TRANSACTION_CAPABLE 46
::constant SQL_USER_NAME 47
::constant SQL_TXN_ISOLATION_OPTION 72
::constant SQL_TRANSACTION_ISOLATION_OPTION 72
::constant SQL_INTEGRITY 73
::constant SQL_GETDATA_EXTENSIONS 81
::constant SQL_NULL_COLLATION 85
::constant SQL_ALTER_TABLE 86
::constant SQL_ORDER_BY_COLUMNS_IN_SELECT 90
::constant SQL_SPECIAL_CHARACTERS 94
::constant SQL_MAX_COLUMNS_IN_GROUP_BY 97
::constant SQL_MAXIMUM_COLUMNS_IN_GROUP_BY 97
::constant SQL_MAX_COLUMNS_IN_INDEX 98
::constant SQL_MAXIMUM_COLUMNS_IN_INDEX 98
::constant SQL_MAX_COLUMNS_IN_ORDER_BY 99
::constant SQL_MAXIMUM_COLUMNS_IN_ORDER_BY 99
::constant SQL_MAX_COLUMNS_IN_SELECT 100
::constant SQL_MAXIMUM_COLUMNS_IN_SELECT 100
::constant SQL_MAX_COLUMNS_IN_TABLE 101
::constant SQL_MAX_INDEX_SIZE 102
::constant SQL_MAXIMUM_INDEX_SIZE 102
::constant SQL_MAX_ROW_SIZE 104
::constant SQL_MAXIMUM_ROW_SIZE 104
::constant SQL_MAX_STATEMENT_LEN 105
::constant SQL_MAXIMUM_STATEMENT_LENGTH 105
::constant SQL_MAX_TABLES_IN_SELECT 106
::constant SQL_MAXIMUM_TABLES_IN_SELECT 106
::constant SQL_MAX_USER_NAME_LEN 107
::constant SQL_MAXIMUM_USER_NAME_LENGTH 107
::constant SQL_OUTER_JOIN_CAPABILITIES 115
-- bit masks/values
::constant SQL_AF_AVG 1
::constant SQL_AF_COUNT 2
::constant SQL_AF_MAX 4
::constant SQL_AF_MIN 8
::constant SQL_AF_SUM 16
::constant SQL_AF_DISTINCT 32
::constant SQL_AF_ALL 64
::constant SQL_AD_CONSTRAINT_NAME_DEFINITION 1
::constant SQL_AD_ADD_DOMAIN_CONSTRAINT 2
::constant SQL_AD_DROP_DOMAIN_CONSTRAINT 4
::constant SQL_AD_ADD_DOMAIN_DEFAULT 8
::constant SQL_AD_DROP_DOMAIN_DEFAULT 16
::constant SQL_AD_ADD_CONSTRAINT_INITIALLY_DEFERRED 32
::constant SQL_AD_ADD_CONSTRAINT_INITIALLY_IMMEDIATE 64
::constant SQL_AD_ADD_CONSTRAINT_DEFERRABLE 128
::constant SQL_AD_ADD_CONSTRAINT_NON_DEFERRABLE 256
::constant SQL_AT_ADD_COLUMN 1
::constant SQL_AT_DROP_COLUMN 2
::constant SQL_AT_ADD_CONSTRAINT 8
::constant SQL_AT_ADD_COLUMN_SINGLE 32
::constant SQL_AT_ADD_COLUMN_DEFAULT 64
::constant SQL_AT_ADD_COLUMN_COLLATION 128
::constant SQL_AT_SET_COLUMN_DEFAULT 256
::constant SQL_AT_DROP_COLUMN_DEFAULT 512
::constant SQL_AT_DROP_COLUMN_CASCADE 1024
::constant SQL_AT_DROP_COLUMN_RESTRICT 2048
::constant SQL_AT_ADD_TABLE_CONSTRAINT 4096
::constant SQL_AT_DROP_TABLE_CONSTRAINT_CASCADE 8192
::constant SQL_AT_DROP_TABLE_CONSTRAINT_RESTRICT 16384
::constant SQL_AT_CONSTRAINT_NAME_DEFINITION 32768
::constant SQL_AT_CONSTRAINT_INITIALLY_DEFERRED 65536
::constant SQL_AT_CONSTRAINT_INITIALLY_IMMEDIATE 131072
::constant SQL_AT_CONSTRAINT_DEFERRABLE 262144
::constant SQL_AT_CONSTRAINT_NON_DEFERRABLE 524288
::constant SQL_AM_CONNECTION 1
::constant SQL_AM_STATEMENT 2
::constant SQL_BRC_PROCEDURES 1
::constant SQL_BRC_EXPLICIT 2
::constant SQL_BRC_ROLLED_UP 4
::constant SQL_BS_SELECT_EXPLICIT 1
::constant SQL_BS_ROW_COUNT_EXPLICIT 2
::constant SQL_BS_SELECT_PROC 4
::constant SQL_BS_ROW_COUNT_PROC 8
::constant SQL_BP_CLOSE 1
::constant SQL_BP_DELETE 2
::constant SQL_BP_DROP 4
::constant SQL_BP_TRANSACTION 8
::constant SQL_BP_UPDATE 16
::constant SQL_BP_OTHER_HSTMT 32
::constant SQL_BP_SCROLL 64
::constant SQL_CL_START 1
::constant SQL_CL_END 2
::constant SQL_QL_START 1
::constant SQL_QL_END 2
::constant SQL_CU_DML_STATEMENTS 1
::constant SQL_CU_PROCEDURE_INVOCATION 2
::constant SQL_CU_TABLE_DEFINITION 4
::constant SQL_CU_INDEX_DEFINITION 8
::constant SQL_CU_PRIVILEGE_DEFINITION 16
::constant SQL_CB_NULL 0
::constant SQL_CB_NON_NULL 1
::constant SQL_CB_DELETE 0
::constant SQL_CB_CLOSE 1
::constant SQL_CB_PRESERVE 2
::constant SQL_CVT_CHAR 1
::constant SQL_CVT_NUMERIC 2
::constant SQL_CVT_DECIMAL 4
::constant SQL_CVT_INTEGER 8
::constant SQL_CVT_SMALLINT 16
::constant SQL_CVT_FLOAT 32
::constant SQL_CVT_REAL 64
::constant SQL_CVT_DOUBLE 128
::constant SQL_CVT_VARCHAR 256
::constant SQL_CVT_LONGVARCHAR 512
::constant SQL_CVT_BINARY 1024
::constant SQL_CVT_VARBINARY 2048
::constant SQL_CVT_BIT 4096
::constant SQL_CVT_TINYINT 8192
::constant SQL_CVT_BIGINT 16384
::constant SQL_CVT_DATE 32768
::constant SQL_CVT_TIME 65536
::constant SQL_CVT_TIMESTAMP 131072
::constant SQL_CVT_LONGVARBINARY 262144
::constant SQL_CVT_INTERVAL_YEAR_MONTH 524288
::constant SQL_CVT_INTERVAL_DAY_TIME 1048576
::constant SQL_CVT_WCHAR 2097152
::constant SQL_CVT_WLONGVARCHAR 4194304
::constant SQL_CVT_WVARCHAR 8388608
::constant SQL_CVT_GUID 16777216
::constant SQL_FN_CVT_CONVERT 1
::constant SQL_FN_CVT_CAST 2
::constant SQL_CN_NONE 0
::constant SQL_CN_DIFFERENT 1
::constant SQL_CN_ANY 2
::constant SQL_CA_CREATE_ASSERTION 1
::constant SQL_CA_CONSTRAINT_INITIALLY_DEFERRED 16
::constant SQL_CA_CONSTRAINT_INITIALLY_IMMEDIATE 32
::constant SQL_CA_CONSTRAINT_DEFERRABLE 64
::constant SQL_CA_CONSTRAINT_NON_DEFERRABLE 128
::constant SQL_CCS_CREATE_CHARACTER_SET 1
::constant SQL_CCS_COLLATE_CLAUSE 2
::constant SQL_CCS_LIMITED_COLLATION 4
::constant SQL_CCOL_CREATE_COLLATION 1
::constant SQL_CDO_CREATE_DOMAIN 1
::constant SQL_CDO_DEFAULT 2
::constant SQL_CDO_CONSTRAINT 4
::constant SQL_CDO_COLLATION 8
::constant SQL_CDO_CONSTRAINT_NAME_DEFINITION 16
::constant SQL_CDO_CONSTRAINT_INITIALLY_DEFERRED 32
::constant SQL_CDO_CONSTRAINT_INITIALLY_IMMEDIATE 64
::constant SQL_CDO_CONSTRAINT_DEFERRABLE 128
::constant SQL_CDO_CONSTRAINT_NON_DEFERRABLE 256
::constant SQL_CS_CREATE_SCHEMA 1
::constant SQL_CS_AUTHORIZATION 2
::constant SQL_CS_DEFAULT_CHARACTER_SET 4
::constant SQL_CT_CREATE_TABLE 1
::constant SQL_CT_COMMIT_PRESERVE 2
::constant SQL_CT_COMMIT_DELETE 4
::constant SQL_CT_GLOBAL_TEMPORARY 8
::constant SQL_CT_LOCAL_TEMPORARY 16
::constant SQL_CT_CONSTRAINT_INITIALLY_DEFERRED 32
::constant SQL_CT_CONSTRAINT_INITIALLY_IMMEDIATE 64
::constant SQL_CT_CONSTRAINT_DEFERRABLE 128
::constant SQL_CT_CONSTRAINT_NON_DEFERRABLE 256
::constant SQL_CT_COLUMN_CONSTRAINT 512
::constant SQL_CT_COLUMN_DEFAULT 1024
::constant SQL_CT_COLUMN_COLLATION 2048
::constant SQL_CT_TABLE_CONSTRAINT 4096
::constant SQL_CT_CONSTRAINT_NAME_DEFINITION 8192
::constant SQL_CTR_CREATE_TRANSLATION 1
::constant SQL_CV_CREATE_VIEW 1
::constant SQL_CV_CHECK_OPTION 2
::constant SQL_CV_CASCADED 4
::constant SQL_CV_LOCAL 8
::constant SQL_DL_SQL92_DATE 1
::constant SQL_DL_SQL92_TIME 2
::constant SQL_DL_SQL92_TIMESTAMP 4
::constant SQL_DL_SQL92_INTERVAL_YEAR 8
::constant SQL_DL_SQL92_INTERVAL_MONTH 16
::constant SQL_DL_SQL92_INTERVAL_DAY 32
::constant SQL_DL_SQL92_INTERVAL_HOUR 64
::constant SQL_DL_SQL92_INTERVAL_MINUTE 128
::constant SQL_DL_SQL92_INTERVAL_SECOND 256
::constant SQL_DL_SQL92_INTERVAL_YEAR_TO_MONTH 512
::constant SQL_DL_SQL92_INTERVAL_DAY_TO_HOUR 1024
::constant SQL_DL_SQL92_INTERVAL_DAY_TO_MINUTE 2048
::constant SQL_DL_SQL92_INTERVAL_DAY_TO_SECOND 4096
::constant SQL_DL_SQL92_INTERVAL_HOUR_TO_MINUTE 8192
::constant SQL_DL_SQL92_INTERVAL_HOUR_TO_SECOND 16384
::constant SQL_DL_SQL92_INTERVAL_MINUTE_TO_SECOND 65536
::constant SQL_UNSPECIFIED 0
::constant SQL_INSENSITIVE 1
::constant SQL_SENSITIVE 2
::constant SQL_DI_CREATE_INDEX 1
::constant SQL_DI_DROP_INDEX 2
::constant SQL_TXN_READ_UNCOMMITTED 1
::constant SQL_TRANSACTION_READ_UNCOMMITTED 1
::constant SQL_TXN_READ_COMMITTED 2
::constant SQL_TRANSACTION_READ_COMMITTED 2
::constant SQL_TXN_REPEATABLE_READ 4
::constant SQL_TRANSACTION_REPEATABLE_READ 4
::constant SQL_TXN_SERIALIZABLE 8
::constant SQL_TRANSACTION_SERIALIZABLE 8
::constant SQL_DA_DROP_ASSERTION 1
::constant SQL_DCS_DROP_CHARACTER_SET 1
::constant SQL_DC_DROP_COLLATION 1
::constant SQL_DD_DROP_DOMAIN 1
::constant SQL_DD_RESTRICT 2
::constant SQL_DD_CASCADE 4
::constant SQL_DT_DROP_TABLE 1
::constant SQL_DT_RESTRICT 2
::constant SQL_DT_CASCADE 4
::constant SQL_DTR_DROP_TRANSLATION 1
::constant SQL_DV_DROP_VIEW 1
::constant SQL_DV_RESTRICT 2
::constant SQL_DV_CASCADE 4
::constant SQL_CA1_NEXT 1
::constant SQL_CA1_ABSOLUTE 2
::constant SQL_CA1_RELATIVE 4
::constant SQL_CA1_BOOKMARK 8
::constant SQL_CA1_LOCK_NO_CHANGE 64
::constant SQL_CA1_LOCK_EXCLUSIVE 128
::constant SQL_CA1_LOCK_UNLOCK 256
::constant SQL_CA1_POS_POSITION 512
::constant SQL_CA1_POS_UPDATE 1024
::constant SQL_CA1_POS_DELETE 2048
::constant SQL_CA1_POS_REFRESH 4096
::constant SQL_CA1_POSITIONED_UPDATE 8192
::constant SQL_CA1_POSITIONED_DELETE 16384
::constant SQL_CA1_SELECT_FOR_UPDATE 32768
::constant SQL_CA1_BULK_ADD 65536
::constant SQL_CA1_BULK_UPDATE_BY_BOOKMARK 131072
::constant SQL_CA1_BULK_DELETE_BY_BOOKMARK 262144
::constant SQL_CA1_BULK_FETCH_BY_BOOKMARK 524288
::constant SQL_CA2_READ_ONLY_CONCURRENCY 1
::constant SQL_CA2_LOCK_CONCURRENCY 2
::constant SQL_CA2_OPT_ROWVER_CONCURRENCY 4
::constant SQL_CA2_OPT_VALUES_CONCURRENCY 8
::constant SQL_CA2_SENSITIVITY_ADDITIONS 16
::constant SQL_CA2_SENSITIVITY_DELETIONS 32
::constant SQL_CA2_SENSITIVITY_UPDATES 64
::constant SQL_CA2_MAX_ROWS_SELECT 128
::constant SQL_CA2_MAX_ROWS_INSERT 256
::constant SQL_CA2_MAX_ROWS_DELETE 512
::constant SQL_CA2_MAX_ROWS_UPDATE 1024
::constant SQL_CA2_MAX_ROWS_CATALOG 2048
::constant SQL_CA2_MAX_ROWS_AFFECTS_ALL 3968
::constant SQL_CA2_CRC_EXACT 4096
::constant SQL_CA2_CRC_APPROXIMATE 8192
::constant SQL_CA2_SIMULATE_NON_UNIQUE 16384
::constant SQL_CA2_SIMULATE_TRY_UNIQUE 32768
::constant SQL_CA2_SIMULATE_UNIQUE 65536
::constant SQL_FILE_NOT_SUPPORTED 0
::constant SQL_FILE_TABLE 1
::constant SQL_FILE_QUALIFIER 2
::constant SQL_FILE_CATALOG 2
::constant SQL_GD_ANY_COLUMN 1
::constant SQL_GD_ANY_ORDER 2
::constant SQL_GD_BLOCK 4
::constant SQL_GD_BOUND 8
::constant SQL_GB_NOT_SUPPORTED 0
::constant SQL_GB_GROUP_BY_EQUALS_SELECT 1
::constant SQL_GB_GROUP_BY_CONTAINS_SELECT 2
::constant SQL_GB_NO_RELATION 3
::constant SQL_GB_COLLATE 4
::constant SQL_IC_UPPER 1
::constant SQL_IC_LOWER 2
::constant SQL_IC_SENSITIVE 3
::constant SQL_IC_MIXED 4
::constant SQL_IK_NONE 0
::constant SQL_IK_ASC 1
::constant SQL_IK_DESC 2
::constant SQL_IK_ALL 3
::constant SQL_ISV_ASSERTIONS 1
::constant SQL_ISV_CHARACTER_SETS 2
::constant SQL_ISV_CHECK_CONSTRAINTS 4
::constant SQL_ISV_COLLATIONS 8
::constant SQL_ISV_COLUMN_DOMAIN_USAGE 16
::constant SQL_ISV_COLUMN_PRIVILEGES 32
::constant SQL_ISV_COLUMNS 64
::constant SQL_ISV_CONSTRAINT_COLUMN_USAGE 128
::constant SQL_ISV_CONSTRAINT_TABLE_USAGE 256
::constant SQL_ISV_DOMAIN_CONSTRAINTS 512
::constant SQL_ISV_DOMAINS 1024
::constant SQL_ISV_KEY_COLUMN_USAGE 2048
::constant SQL_ISV_REFERENTIAL_CONSTRAINTS 4096
::constant SQL_ISV_SCHEMATA 8192
::constant SQL_ISV_SQL_LANGUAGES 16384
::constant SQL_ISV_TABLE_CONSTRAINTS 32768
::constant SQL_ISV_TABLE_PRIVILEGES 65536
::constant SQL_ISV_TABLES 131072
::constant SQL_ISV_TRANSLATIONS 262144
::constant SQL_ISV_USAGE_PRIVILEGES 524288
::constant SQL_ISV_VIEW_COLUMN_USAGE 1048576
::constant SQL_ISV_VIEW_TABLE_USAGE 2097152
::constant SQL_ISV_VIEWS 4194304
::constant SQL_IS_INSERT_LITERALS 1
::constant SQL_IS_INSERT_SEARCHED 2
::constant SQL_IS_SELECT_INTO 4
::constant SQL_NNC_NULL 0
::constant SQL_NNC_NON_NULL 1
::constant SQL_NC_START 2
::constant SQL_NC_END 4
::constant SQL_FN_STR_CONCAT 1
::constant SQL_FN_STR_INSERT 2
::constant SQL_FN_STR_LEFT 4
::constant SQL_FN_STR_LTRIM 8
::constant SQL_FN_STR_LENGTH 16
::constant SQL_FN_STR_LOCATE 32
::constant SQL_FN_STR_LCASE 64
::constant SQL_FN_STR_REPEAT 128
::constant SQL_FN_STR_REPLACE 256
::constant SQL_FN_STR_RIGHT 512
::constant SQL_FN_STR_RTRIM 1024
::constant SQL_FN_STR_SUBSTRING 2048
::constant SQL_FN_STR_UCASE 4096
::constant SQL_FN_STR_ASCII 8192
::constant SQL_FN_STR_CHAR 16384
::constant SQL_FN_STR_DIFFERENCE 32768
::constant SQL_FN_STR_LOCATE_2 65536
::constant SQL_FN_STR_SOUNDEX 131072
::constant SQL_FN_STR_SPACE 262144
::constant SQL_FN_STR_BIT_LENGTH 524288
::constant SQL_FN_STR_CHAR_LENGTH 1048576
::constant SQL_FN_STR_CHARACTER_LENGTH 2097152
::constant SQL_FN_STR_OCTET_LENGTH 4194304
::constant SQL_FN_STR_POSITION 8388608
::constant SQL_FN_NUM_ABS 1
::constant SQL_FN_NUM_ACOS 2
::constant SQL_FN_NUM_ASIN 4
::constant SQL_FN_NUM_ATAN 8
::constant SQL_FN_NUM_ATAN2 16
::constant SQL_FN_NUM_CEILING 32
::constant SQL_FN_NUM_COS 64
::constant SQL_FN_NUM_COT 128
::constant SQL_FN_NUM_EXP 256
::constant SQL_FN_NUM_FLOOR 512
::constant SQL_FN_NUM_LOG 1024
::constant SQL_FN_NUM_MOD 2048
::constant SQL_FN_NUM_SIGN 4096
::constant SQL_FN_NUM_SIN 8192
::constant SQL_FN_NUM_SQRT 16384
::constant SQL_FN_NUM_TAN 32768
::constant SQL_FN_NUM_PI 65536
::constant SQL_FN_NUM_RAND 131072
::constant SQL_FN_NUM_DEGREES 262144
::constant SQL_FN_NUM_LOG10 524288
::constant SQL_FN_NUM_POWER 1048576
::constant SQL_FN_NUM_RADIANS 2097152
::constant SQL_FN_NUM_ROUND 4194304
::constant SQL_FN_NUM_TRUNCATE 8388608
::constant SQL_FN_TD_NOW 1
::constant SQL_FN_TD_CURDATE 2
::constant SQL_FN_TD_DAYOFMONTH 4
::constant SQL_FN_TD_DAYOFWEEK 8
::constant SQL_FN_TD_DAYOFYEAR 16
::constant SQL_FN_TD_MONTH 32
::constant SQL_FN_TD_QUARTER 64
::constant SQL_FN_TD_WEEK 128
::constant SQL_FN_TD_YEAR 256
::constant SQL_FN_TD_CURTIME 512
::constant SQL_FN_TD_HOUR 1024
::constant SQL_FN_TD_MINUTE 2048
::constant SQL_FN_TD_SECOND 4096
::constant SQL_FN_TD_TIMESTAMPADD 8192
::constant SQL_FN_TD_TIMESTAMPDIFF 16384
::constant SQL_FN_TD_DAYNAME 32768
::constant SQL_FN_TD_MONTHNAME 65536
::constant SQL_FN_TD_CURRENT_DATE 131072
::constant SQL_FN_TD_CURRENT_TIME 262144
::constant SQL_FN_TD_CURRENT_TIMESTAMP 524288
::constant SQL_FN_TD_EXTRACT 1048576
::constant SQL_FN_SYS_USERNAME 1
::constant SQL_FN_SYS_DBNAME 2
::constant SQL_FN_SYS_IFNULL 4
::constant SQL_FN_TSI_FRAC_SECOND 1
::constant SQL_FN_TSI_SECOND 2
::constant SQL_FN_TSI_MINUTE 4
::constant SQL_FN_TSI_HOUR 8
::constant SQL_FN_TSI_DAY 16
::constant SQL_FN_TSI_WEEK 32
::constant SQL_FN_TSI_MONTH 64
::constant SQL_FN_TSI_QUARTER 128
::constant SQL_FN_TSI_YEAR 256
::constant SQL_OIC_CORE 1
::constant SQL_OIC_LEVEL1 2
::constant SQL_OIC_LEVEL2 3
::constant SQL_OJ_CAPABILITIES 115
::constant SQL_OJ_LEFT 1
::constant SQL_OJ_RIGHT 2
::constant SQL_OJ_FULL 4
::constant SQL_OJ_NESTED 8
::constant SQL_OJ_NOT_ORDERED 16
::constant SQL_OJ_INNER 32
::constant SQL_OJ_ALL_COMPARISON_OPS 64
::constant SQL_PARC_BATCH 1
::constant SQL_PARC_NO_BATCH 2
::constant SQL_PAS_BATCH 1
::constant SQL_PAS_NO_BATCH 2
::constant SQL_PAS_NO_SELECT 3
::constant SQL_POS_POSITION 1
::constant SQL_POS_REFRESH 2
::constant SQL_POS_UPDATE 4
::constant SQL_POS_DELETE 8
::constant SQL_POS_ADD 16
::constant SQL_SU_DML_STATEMENTS 1
::constant SQL_SU_PROCEDURE_INVOCATION 2
::constant SQL_SU_TABLE_DEFINITION 4
::constant SQL_SU_INDEX_DEFINITION 8
::constant SQL_SU_PRIVILEGE_DEFINITION 16
::constant SQL_SO_FORWARD_ONLY 1
::constant SQL_SO_KEYSET_DRIVEN 2
::constant SQL_SO_DYNAMIC 4
::constant SQL_SO_MIXED 8
::constant SQL_SO_STATIC 16
::constant SQL_SC_SQL92_ENTRY 1
::constant SQL_SC_FIPS127_2_TRANSITIONAL 2
::constant SQL_SC_SQL92_INTERMEDIATE 4
::constant SQL_SC_SQL92_FULL 8
::constant SQL_SDF_CURRENT_DATE 1
::constant SQL_SDF_CURRENT_TIME 2
::constant SQL_SDF_CURRENT_TIMESTAMP 4
::constant SQL_SFKD_CASCADE 1
::constant SQL_SFKD_NO_ACTION 2
::constant SQL_SFKD_SET_DEFAULT 4
::constant SQL_SFKD_SET_NULL 8
::constant SQL_SFKU_CASCADE 1
::constant SQL_SFKU_NO_ACTION 2
::constant SQL_SFKU_SET_DEFAULT 4
::constant SQL_SFKU_SET_NULL 8
::constant SQL_SG_USAGE_ON_DOMAIN 1
::constant SQL_SG_USAGE_ON_CHARACTER_SET 2
::constant SQL_SG_USAGE_ON_COLLATION 4
::constant SQL_SG_USAGE_ON_TRANSLATION 8
::constant SQL_SG_WITH_GRANT_OPTION 16
::constant SQL_SG_DELETE_TABLE 32
::constant SQL_SG_INSERT_TABLE 64
::constant SQL_SG_INSERT_COLUMN 128
::constant SQL_SG_REFERENCES_TABLE 256
::constant SQL_SG_REFERENCES_COLUMN 512
::constant SQL_SG_SELECT_TABLE 1024
::constant SQL_SG_UPDATE_TABLE 2048
::constant SQL_SG_UPDATE_COLUMN 4096
::constant SQL_SNVF_BIT_LENGTH 1
::constant SQL_SNVF_CHAR_LENGTH 2
::constant SQL_SNVF_CHARACTER_LENGTH 4
::constant SQL_SNVF_EXTRACT 8
::constant SQL_SNVF_OCTET_LENGTH 16
::constant SQL_SNVF_POSITION 32
::constant SQL_SP_EXISTS 1
::constant SQL_SP_ISNOTNULL 2
::constant SQL_SP_ISNULL 4
::constant SQL_SP_MATCH_FULL 8
::constant SQL_SP_MATCH_PARTIAL 16
::constant SQL_SP_MATCH_UNIQUE_FULL 32
::constant SQL_SP_MATCH_UNIQUE_PARTIAL 64
::constant SQL_SP_OVERLAPS 128
::constant SQL_SP_UNIQUE 256
::constant SQL_SP_LIKE 512
::constant SQL_SP_IN 1024
::constant SQL_SP_BETWEEN 2048
::constant SQL_SP_COMPARISON 4096
::constant SQL_SP_QUANTIFIED_COMPARISON 8192
::constant SQL_SRJO_CORRESPONDING_CLAUSE 1
::constant SQL_SRJO_CROSS_JOIN 2
::constant SQL_SRJO_EXCEPT_JOIN 4
::constant SQL_SRJO_FULL_OUTER_JOIN 8
::constant SQL_SRJO_INNER_JOIN 16
::constant SQL_SRJO_INTERSECT_JOIN 32
::constant SQL_SRJO_LEFT_OUTER_JOIN 64
::constant SQL_SRJO_NATURAL_JOIN 128
::constant SQL_SRJO_RIGHT_OUTER_JOIN 256
::constant SQL_SRJO_UNION_JOIN 512
::constant SQL_SR_USAGE_ON_DOMAIN 1
::constant SQL_SR_USAGE_ON_CHARACTER_SET 2
::constant SQL_SR_USAGE_ON_COLLATION 4
::constant SQL_SR_USAGE_ON_TRANSLATION 8
::constant SQL_SR_GRANT_OPTION_FOR 16
::constant SQL_SR_CASCADE 32
::constant SQL_SR_RESTRICT 64
::constant SQL_SR_DELETE_TABLE 128
::constant SQL_SR_INSERT_TABLE 256
::constant SQL_SR_INSERT_COLUMN 512
::constant SQL_SR_REFERENCES_TABLE 1024
::constant SQL_SR_REFERENCES_COLUMN 2048
::constant SQL_SR_SELECT_TABLE 4096
::constant SQL_SR_UPDATE_TABLE 8192
::constant SQL_SR_UPDATE_COLUMN 16384
::constant SQL_SRVC_VALUE_EXPRESSION 1
::constant SQL_SRVC_NULL 2
::constant SQL_SRVC_DEFAULT 4
::constant SQL_SRVC_ROW_SUBQUERY 8
::constant SQL_SSF_CONVERT 1
::constant SQL_SSF_LOWER 2
::constant SQL_SSF_UPPER 4
::constant SQL_SSF_SUBSTRING 8
::constant SQL_SSF_TRANSLATE 16
::constant SQL_SSF_TRIM_BOTH 32
::constant SQL_SSF_TRIM_LEADING 64
::constant SQL_SSF_TRIM_TRAILING 128
::constant SQL_SVE_CASE 1
::constant SQL_SVE_CAST 2
::constant SQL_SVE_COALESCE 4
::constant SQL_SVE_NULLIF 8
::constant SQL_SCC_XOPEN_CLI_VERSION1 1
::constant SQL_SCC_ISO92_CLI 2
::constant SQL_SQ_COMPARISON 1
::constant SQL_SQ_EXISTS 2
::constant SQL_SQ_IN 4
::constant SQL_SQ_QUANTIFIED 8
::constant SQL_SQ_CORRELATED_SUBQUERIES 16
::constant SQL_TC_NONE 0
::constant SQL_TC_DML 1
::constant SQL_TC_ALL 2
::constant SQL_TC_DDL_COMMIT 3
::constant SQL_TC_DDL_IGNORE 4
::constant SQL_U_UNION 1
::constant SQL_U_UNION_ALL 2
/*----------------------------------------------------------------------------*/
/* Class: dbconnx */
/*----------------------------------------------------------------------------*/
::class dbconnx public subclass cli
::method init EXTERNAL "Library orxsql OrxDB_dbinit"
::method get_env_attr EXTERNAL "Library orxsql OrxDB_get_env_attr"
::method set_env_attr EXTERNAL "Library orxsql OrxDB_set_env_attr"
::method connect EXTERNAL "Library orxsql OrxDB_connect"
::method disconnect EXTERNAL "Library orxsql OrxDB_close"
::method get_connect_attr EXTERNAL "Library orxsql OrxDB_get_connx_attr"
::method set_connect_attr EXTERNAL "Library orxsql OrxDB_set_connx_attr"
::method commit EXTERNAL "Library orxsql OrxDB_commit"
::method rollback EXTERNAL "Library orxsql OrxDB_rollback"
::method isConnected EXTERNAL "Library orxsql OrxDB_check_connx"
::method get_info EXTERNAL "Library orxsql OrxDB_get_info"
::method destroy EXTERNAL "Library orxsql OrxDB_destroy"
/*----------------------------------------------------------------------------*/
/* Class: SQLstatement */
/*----------------------------------------------------------------------------*/
::class SQLstatement public subclass cli
::attribute stmt
::method init EXTERNAL "Library orxsql OrxDB_stmtinit"
::method execute EXTERNAL "Library orxsql OrxDB_execute"
::method execDirect EXTERNAL "Library orxsql OrxDB_execdirect"
::method bindParms EXTERNAL "Library orxsql OrxDB_bind_parms"
::method prepare EXTERNAL "Library orxsql OrxDB_prepare"
::method fetch EXTERNAL "Library orxsql OrxDB_fetch"
::method numResultCols EXTERNAL "Library orxsql OrxDB_num_result_cols"
::method getData EXTERNAL "Library orxsql OrxDB_get_data"
::method get_attr EXTERNAL "Library orxsql OrxDB_get_stmt_attr"
::method set_attr EXTERNAL "Library orxsql OrxDB_set_stmt_attr"
::method get_stmt_attr EXTERNAL "Library orxsql OrxDB_get_stmt_attr"
::method set_stmt_attr EXTERNAL "Library orxsql OrxDB_set_stmt_attr"
::method destroy EXTERNAL "Library orxsql OrxDB_stmtdestroy"
::method getRow
-- after a successful fetch is performed this will return all columns as an array
n = self~numResultCols()
arr = .array~new(n)
do i = 1 to n
arr[i] = self~getData(i)
end
return arr