Author |
Message |
Topic: recompilation of DB2 Program. |
manojvoona
Replies: 3
Views: 1435
|
Forum: Database Posted: Mon May 04, 2009 4:12 pm Subject: recompilation of DB2 Program. |
Thanks Kolusu for confirmation...... for safety do you want us to rebind the plan ?
Thanks
Manoj |
Topic: recompilation of DB2 Program. |
manojvoona
Replies: 3
Views: 1435
|
Forum: Database Posted: Mon May 04, 2009 3:17 pm Subject: recompilation of DB2 Program. |
Hi,
I have a quick question on DB2 program recompilation.
Do we need to recompile all the online and batch DB2 program if a new field is added to the table ? we did not recompile last time when w ... |
Topic: CRLF at the end of records |
manojvoona
Replies: 5
Views: 4164
|
Forum: Utilities Posted: Thu Jan 31, 2008 2:36 pm Subject: CRLF at the end of records |
Thanks Kolusu,
Yaah you are right. The vendor system is windows.
They are able to see LF only in the file
We inserted CR using a Syncsort and that worked.
Thanks for all the help. we really ... |
Topic: CRLF at the end of records |
manojvoona
Replies: 5
Views: 4164
|
Forum: Utilities Posted: Thu Jan 31, 2008 12:21 pm Subject: CRLF at the end of records |
Thanks Kolusu,
How do I get to know if the file has CRLF at the end.
the file length is 300 and data is populated uptill 300. will it be after 300 bytes.
Can you help me in writing the DFSORT t ... |
Topic: CRLF at the end of records |
manojvoona
Replies: 5
Views: 4164
|
Forum: Utilities Posted: Thu Jan 31, 2008 11:13 am Subject: CRLF at the end of records |
Hi ,
I really need help in this.
We need to send some date ( file ) to a vendor system. Their system is on Unix.
They are expectigng CRLF at the end of each record.
Some how when we transfer t ... |
Topic: Pad zeroes to left justified numeric data |
manojvoona
Replies: 5
Views: 2726
|
Forum: Utilities Posted: Mon Jun 18, 2007 3:05 pm Subject: Pad zeroes to left justified numeric data |
thanks for all,
The UFF format worked.
Thanks
Manoj Voona |
Topic: Pad zeroes to left justified numeric data |
manojvoona
Replies: 5
Views: 2726
|
Forum: Utilities Posted: Wed Jun 13, 2007 3:22 pm Subject: Pad zeroes to left justified numeric data |
Sorry Phantom,
thanks for the help !!!!! |
Topic: Pad zeroes to left justified numeric data |
manojvoona
Replies: 5
Views: 2726
|
Forum: Utilities Posted: Wed Jun 13, 2007 3:00 pm Subject: Pad zeroes to left justified numeric data |
Hi,
I am sorry if some one has asked you the same questions. I Could not fine in the forum.
Here is my questions
I have a file with account number 12 digits. But the number is left indented, t ... |
Topic: xpeditor/cics |
manojvoona
Replies: 4
Views: 2566
|
Forum: Utilities Posted: Tue May 15, 2007 1:41 pm Subject: xpeditor/cics |
Hi Kolusu,
This links is not working. Can you please give us the new link where I can find the xpediter/cics.
Thanks a Lot
Manoj Voona |
Topic: Learning SAS |
manojvoona
Replies: 2
Views: 1732
|
Forum: Utilities Posted: Thu Jan 25, 2007 2:16 am Subject: Learning SAS |
Thanks Kolusu.. Thanks a lot
-Manoj Voona |
Topic: Learning SAS |
manojvoona
Replies: 2
Views: 1732
|
Forum: Utilities Posted: Wed Jan 24, 2007 1:09 am Subject: Learning SAS |
Hi ,
I dont know if this is the correct forum to discuss this. Pardon me if this is wrong place
SAS was installed in out shop and business wants to us to create some reports accessing DB2 tab ... |
Topic: Generate Sql Statement to Update Table using SORT |
manojvoona
Replies: 2
Views: 1830
|
Forum: Database Posted: Mon Jan 22, 2007 12:55 pm Subject: Generate Sql Statement to Update Table using SORT |
Thanks Kolusu !!! thanks a lot.
This is awesome.
-Manoj Voona |
Topic: Generate Sql Statement to Update Table using SORT |
manojvoona
Replies: 2
Views: 1830
|
Forum: Database Posted: Sun Jan 21, 2007 9:46 pm Subject: Generate Sql Statement to Update Table using SORT |
Hi ,
We Need some help in writing update query.
We have a input file of 10,000 records with account number and update value. We need to generate the update query along with Commits in betweej o ... |
Topic: Tapes help |
manojvoona
Replies: 13
Views: 11243
|
Forum: Job Control Language(JCL) Posted: Wed Jan 17, 2007 5:40 pm Subject: Tapes help |
Hi Bill,
Thanks for your reply.
Here is the spool information when I ran the above job.
16.26.10 JOB09720 IEC502E K 0425,A20411,SL,TSO5151A,STEP1OF1
16.26.10 JOB09720 TMS014 ... |
Topic: Tapes help |
manojvoona
Replies: 13
Views: 11243
|
Forum: Job Control Language(JCL) Posted: Wed Jan 17, 2007 12:12 am Subject: Tapes help |
Thanks Bill,
Thanks for your Reply !!!.
Can you please help us in resolving some questions.
1. we are not able to get the PDS NAME of the tape.
In the Step you mentioned it as DSN=DUMP.TAPE. ... |
|