Search found 6 matches
- Thu Mar 26, 2009 4:44 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: Load replace/resume, REORG related query.
- Replies: 1
- Views: 6118
Load replace/resume, REORG related query.
Hi, I have a LOAD REPLACE job. I want to modify it to be a LOAD RESUME job. Is it necessary to schedule a REORG job after LOAD RESUME job? If yes, then why? If no, then also why? Can programmers create REORG job for testing purpose or only DBAs have authority to create them? Please reply soon. Thank...
- Thu Jan 29, 2009 9:33 am
- Forum: DFSORT , ICETOOL & Utilities
- Topic: ALTSEQ statement
- Replies: 8
- Views: 13423
- Tue Jan 27, 2009 4:24 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: ALTSEQ statement
- Replies: 8
- Views: 13423
ALTSEQ statement
Hi, I have a querry regarding ALTSEQ statement. My input looks like this ----+----1----+----2----+ -00000-00000USD2.. -00000-00000USD... When I used ALTSEQ statement, all the undisplayable characters i.e. ( all '.' ) were replaced by spaces and I got the o/p as ----+----1----+----2----+ -00000-00000...
- Fri Aug 01, 2008 2:16 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: How to add two coloumns of table inm DB2
- Replies: 0
- Views: 6483
How to add two coloumns of table inm DB2
Hi Can any one help me how to add 2 coloumns in the table having two differnt data types and giving the result to third field for ex: 01 Date_field pic X(10) 01 Col_A Smallint find the blow commend COALESCE(CAST(PROG_END_DT+GRACE_PRD_CT AS CHAR(10)),'N/A') AS GRACE_PRD_CT with this you can add/subst...
- Thu Jul 31, 2008 5:48 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Regarding date comparision using dfsort urgent
- Replies: 2
- Views: 7796
- Fri Jul 25, 2008 10:14 am
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Regarding date comparision using dfsort urgent
- Replies: 2
- Views: 7796
Regarding date comparision using dfsort urgent
Hi, i have a sort card where i am comparing one of my date field with system date the code is INCLUDE=(9,10,CH,LT,&DATE1(-)-6) Then it work proper where as INCLUDE=(9,10,CH,LT,(&DATE1(-)-19,2,BI)) (19,2,CH) Is my field which is defined in layout and having the value '6' above and in this case teh so...