 |
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 10 matches |
| Author | Message |
|---|---|
 Topic: BMC Unload |
|
| shreyas_e Replies: 3 Views: 3326 |
 Forum: Database Posted: Thu May 30, 2019 4:38 pm Subject: BMC Unload |
| Thanks Nic and Kolusu | |
| Topic: BMC Unload |
|
| shreyas_e Replies: 3 Views: 3326 |
Forum: Database Posted: Wed May 29, 2019 2:23 pm Subject: BMC Unload |
| Hi, We are working on a project to unload DB2 data into a file and FTP it to AWS S3. I am running the BMC Unload utility(ADUUMAIN) now and it works fine and extracts the data in CSV format. However, I ... | |
| Topic: SQLCODE -567 while creating stored procedure |
|
| shreyas_e Replies: 3 Views: 2884 |
Forum: Database Posted: Thu Apr 04, 2019 3:51 pm Subject: SQLCODE -567 while creating stored procedure |
| Hi Kolusu,
Thanks for looking in to this. We have DB2 10, 11 and 12. In all the versions i get the same error. Not sure if this is something else, before reaching out to DB2 Admin. Thanks Shrey ... |
|
| Topic: SQLCODE -567 while creating stored procedure |
|
| shreyas_e Replies: 3 Views: 2884 |
Forum: Database Posted: Thu Apr 04, 2019 12:10 pm Subject: SQLCODE -567 while creating stored procedure |
| Hi,
I am trying to create the below stored procedure. This is the first time I am trying to create a Stored procedure. SET CURRENT SQLID = ' ... |
|
| Topic: RECORDSIZE of ALTERNATEINDEX |
|
| shreyas_e Replies: 2 Views: 3257 |
Forum: Data Management Posted: Mon Jul 23, 2018 11:33 am Subject: RECORDSIZE of ALTERNATEINDEX |
| Hi,
The below is from IBM Website. Is there any way we can have the RECORDSIZE of ALTERNATEINDEX more than 32767. I have a requirement where my ALTERNATEINDEX with NONUNIQUE keys exceeds 32767. Pl ... |
|
| Topic: Packed Decimal sign bit 'A' issue |
|
| shreyas_e Replies: 8 Views: 3316 |
Forum: Application Programming Posted: Tue Nov 07, 2017 3:25 pm Subject: Packed Decimal sign bit 'A' issue |
| Sorry for the trouble Kolusu. Its working. Thanks for your help | |
| Topic: Packed Decimal sign bit 'A' issue |
|
| shreyas_e Replies: 8 Views: 3316 |
Forum: Application Programming Posted: Tue Nov 07, 2017 2:10 pm Subject: Packed Decimal sign bit 'A' issue |
| Hi Kolusu,
I am trying to use the example DFSORT you have provided. I would like to change the sign from 'A' to 'C'. The second IFTHEN checks for 'A', but I am not sure how to change it to 'C' and ... |
|
| Topic: Packed Decimal sign bit 'A' issue |
|
| shreyas_e Replies: 8 Views: 3316 |
Forum: Application Programming Posted: Tue Nov 07, 2017 10:51 am Subject: Packed Decimal sign bit 'A' issue |
| Hi Kolusu,
Sorry. I have been trying many tests. May be I did not post the correct information. !@#$^ î̪qÎè è g_ 57755135799753153186 ACBBF2468A8642C4297D I am using ... |
|
| Topic: Packed Decimal sign bit 'A' issue |
|
| shreyas_e Replies: 8 Views: 3316 |
Forum: Application Programming Posted: Tue Nov 07, 2017 9:59 am Subject: Packed Decimal sign bit 'A' issue |
| Hi Kolusu,
Thanks for your response. I tried using NUMPROC(NOPFD), but it did not work. I think NUMPROC(NOPFD) will work in conjunction with NUMCLS option. NUMPROC(NOPFD) along with NUMCLS(ALT) wil ... |
|
| Topic: Packed Decimal sign bit 'A' issue |
|
| shreyas_e Replies: 8 Views: 3316 |
Forum: Application Programming Posted: Tue Nov 07, 2017 8:47 am Subject: Packed Decimal sign bit 'A' issue |
| We have a Master file which has S9(11)V9(2) COMP-3 field, which has Amounts populated.
- For some records this field has Junk values also. - There are some records which have the amount populate ... |
|
All times are GMT - 5 Hours |