 |
MVSFORUMS.com A Community of and for MVS Professionals
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
| Search found 8 matches |
| Author | Message |
|---|---|
 Topic: Mass Data load into DB2 tables - SQL INSERT or LOAD UTLITY ? |
|
| ajeykumar Replies: 7 Views: 6835 |
 Forum: Database Posted: Tue Jan 28, 2003 12:48 am Subject: Mass Data load into DB2 tables - SQL INSERT or LOAD UTLITY ? |
| HI Pradeep,
It is possible the DBAs give you a good earful for running the REPAIR utility to remove the check pending status. Instead of incorporating the constraints' check and RI check into y ... |
|
| Topic: Mass Data load into DB2 tables - SQL INSERT or LOAD UTLITY ? |
|
| ajeykumar Replies: 7 Views: 6835 |
Forum: Database Posted: Thu Jan 23, 2003 1:31 am Subject: Mass Data load into DB2 tables - SQL INSERT or LOAD UTLITY ? |
| HI Pradeep and Kolusu,
Just as a thought, switching OFF the constraints before running the load utility and then turning them ON again once the load is done may make your load utility run faster. ... |
|
| Topic: Shuffle the contents of a column |
|
| ajeykumar Replies: 2 Views: 3383 |
Forum: Database Posted: Tue Jan 21, 2003 7:27 am Subject: Shuffle the contents of a column |
| Maybe you could also try it like this:
UPDATE Table_name SET Column_name = SUBSTR(Col, LOCATE (',', Col), 50 ) || ',' || SUBSTR(Col, 1, LOCATE (',', Col)) Di ... |
|
| Topic: DB2 Fetch cursor |
|
| ajeykumar Replies: 6 Views: 4611 |
Forum: Database Posted: Tue Jan 14, 2003 11:33 pm Subject: DB2 Fetch cursor |
| Thanks Ravi. I will try that.
Ajey |
|
| Topic: comparing two files and adding record to new file.. |
|
| ajeykumar Replies: 12 Views: 8817 |
Forum: Utilities Posted: Thu Jan 09, 2003 5:19 am Subject: comparing two files and adding record to new file.. |
| If the files contain unique records, you can perform this task by using series of SORTs.
(1) append old file with the number '1' - OUTREC func in sort (2) append new file with the number '2' - OUT ... |
|
| Topic: TimeStamp Mismatch Fix |
|
| ajeykumar Replies: 4 Views: 6727 |
Forum: Database Posted: Tue Jan 07, 2003 12:24 am Subject: TimeStamp Mismatch Fix |
| Just as an afterthought, the entire process of a timestamp mismatch occuring is:
When the precompile is done, the timestamp is placed in SYSIBM.SYSDBRM when the DBRM is created. Also, this same tim ... |
|
| Topic: DB2 Fetch cursor |
|
| ajeykumar Replies: 6 Views: 4611 |
Forum: Database Posted: Mon Dec 16, 2002 3:50 am Subject: DB2 Fetch cursor |
| Thanks for the replies.
As I had mentioned, the Isolation level is set to CS and not UR. The CURRENTDATA is set to NO. Maybe the question here should be "Can there be a change in the number of ... |
|
| Topic: DB2 Fetch cursor |
|
| ajeykumar Replies: 6 Views: 4611 |
Forum: Database Posted: Thu Dec 12, 2002 3:26 am Subject: DB2 Fetch cursor |
| I faced a unique case yesterday which I had never experienced before and would like to get your views on the same.
In my app program, I have a cursor for a specific WHERE condition. In the program ... |
|
All times are GMT - 5 Hours |