Search found 44 matches
- Fri Jul 08, 2016 12:24 pm
- Forum: COBOL
- Topic: Double Byte Character validation
- Replies: 0
- Views: 3777
Double Byte Character validation
Team - We use Japanese character - Kanji Character set to load our database. I see we are receiving invalid Double byte character which is causing the DB load process to get failed and leading other downstream issues. So I'm looking for any logic in COBOL we can do validation on the data which is re...
- Thu Sep 26, 2013 1:42 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Create file from SORTOUT FILE
- Replies: 1
- Views: 2601
Create file from SORTOUT FILE
Hi, I''m trying to create a file dynamically based on the file reception time and date including microseconds. I have created the and file name how I required and it is available in SORTOUT file. Can you please help me out can I use that file name A.B.C in the SORTOUT file to be created as a FILE NA...
- Fri Dec 02, 2011 11:23 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: DBXX NOT OPERATIONAL, RETRY COUNT IS ZERO
- Replies: 7
- Views: 12725
DBXX NOT OPERATIONAL, RETRY COUNT IS ZERO
Hi archup20,
Have you pointed the DB2 tables using Route card ? Have you checked whether the DBXX region which you are trying to read / update is available when you run the job. check master logs before you re-start the job.
Best Regards,
Harikrishnan
Have you pointed the DB2 tables using Route card ? Have you checked whether the DBXX region which you are trying to read / update is available when you run the job. check master logs before you re-start the job.
Best Regards,
Harikrishnan
- Fri Dec 02, 2011 11:17 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: Update DB2 table using any utility
- Replies: 1
- Views: 3297
Update DB2 table using any utility
Hi all, I have a requirement that I need to update the database once I get the feed, but the key fields will be inserted by another job. Based on the key fields i need to update other few column detail since those values are available in the file only. Is there any utility which will update the valu...
- Fri Dec 02, 2011 11:11 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Find and Replace @ Diff positions.
- Replies: 1
- Views: 3788
Find and Replace @ Diff positions.
Hi All, Can anyone help me with my requirement. My output file contains some incorrect / invalid character I know its HEX values. But I need to replace these HEX values in 2 different ranges. 1) Input file (Sortin) is LRECL 128 2) RECFM = fb 3) First range is from 10-26 4) Second Range is from 70-86...
- Fri Oct 14, 2011 11:04 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Compare FB with VB to get VB file
- Replies: 2
- Views: 9947
Compare FB with VB to get VB file
Hi All, I have a requirement to extract the file, I used Key file as a FB file of 20 LRECL and the data file as 4096 LRECL VB file. The actual data is only 4092 and 4 byte is RDW. My keys are @ first 10 position in both the Key and the data file. I used SORT to match between these two files and extr...
- Wed Oct 12, 2011 4:16 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Sort Multiple file with Diff LRECL's
- Replies: 2
- Views: 7227
- Tue Oct 11, 2011 10:45 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Sort Multiple file with Diff LRECL's
- Replies: 2
- Views: 7227
Sort Multiple file with Diff LRECL's
Hi All, I have a requirement and I have to do this in different steps, is there any way that we can do this in a single SORT STEP. Requirement: 1) 11 input files and all are different LRECL. 2) My sort key for all 11 diffferent file are @ different positions. 3) Currently 11 output files are created...
- Mon Sep 19, 2011 11:56 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: Point to Specific Partition in the DB
- Replies: 2
- Views: 4186
Hi Dick, Thanks for your update. I can accomplish this by placing exclusive hold on the jobs. We can place one job on hold while the other updates / inserts / delets the database so that this will avoid less failure of the job to get failed due to contention. Yes, I need to load the database with th...
- Sat Sep 17, 2011 11:31 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: Point to Specific Partition in the DB
- Replies: 2
- Views: 4186
Point to Specific Partition in the DB
Hi All, Can someone let me know whether shall we point to a specific partition (either update or select or Load) if I know that i will data only for that partition. If i perform this I can avoid contention between jobs. Also I have created my test table where this has 110 columns and total LRECL is ...
- Sun Aug 21, 2011 9:17 am
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: BMC Load REPLACE option
- Replies: 5
- Views: 11377
- Sun Aug 21, 2011 7:58 am
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: BMC Load REPLACE option
- Replies: 5
- Views: 11377
Thanks for your suggestion. Since this is a Dev data, i don't think that there will be some backup for my database. I will check with Storage mgmt team if they run any scripts for this at back end for all Dev databases. I checked whether there is any Full image copy for my database. I could not find...
- Sat Aug 20, 2011 1:55 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: BMC Load REPLACE option
- Replies: 5
- Views: 11377
BMC Load REPLACE option
Hi All, I tried to load my Dev table and my table had some lakhs of records, now, unknowingly I used the below Load card to load the database. LOAD REPLACE LOG NO ORDER YES COPY YES UPDATEDB2STATS YES BMCSTATS YES REDEFINE NO INTO TABLE ABCD.TABLE_1_TEST Unfortunately I load all my old data in the t...
- Tue Mar 29, 2011 4:10 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Need help to compare 2 files and write the matched records
- Replies: 18
- Views: 40695
Need help to compare 2 files and write the matched records
Hi Preeti, Here is the SORT Card which will work in SYNCSORT !!!! //S1 EXEC PGM=SORT //SYSOUT DD SYSOUT=* //IN1 DD DSN=... input file1 (FB/8) //IN2 DD DSN=... input file2 (FB/107) //SORTOUT DD DSN=... output file (FB/99) //SYSIN DD * JOINKEYS FILE=F1,FIELDS=(1,8,A) JO...
- Mon Feb 28, 2011 12:34 am
- Forum: Admin Announcements
- Topic: DB2 QUICK START - FREE for Members
- Replies: 81
- Views: 154952