Search found 6 matches

by paheli
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...
by paheli
Thu Jan 29, 2009 9:33 am
Forum: DFSORT , ICETOOL & Utilities
Topic: ALTSEQ statement
Replies: 8
Views: 13423

Hi Frank Thanks for your quick reply. Please find the explanation for the stated problem below, For example:- My input is like this, EMPLOYEE- EMPLOYEE-CODE NAME 5/AN 5/AN (1-5) (6-10) 1------------ 2------------ *************************** GIRI3 11111 GIRI2 22??2 GIRI1 33333 GIRI5 4...
by paheli
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...
by paheli
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...
by paheli
Thu Jul 31, 2008 5:48 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Regarding date comparision using dfsort urgent
Replies: 2
Views: 7796

thanks
:lol:
by paheli
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...