Hi Krishna,
Please provide the password number for 450
Many thanks in advance
Harikrishnan
Search found 44 matches
- Fri Feb 25, 2011 11:33 pm
- Forum: Admin Announcements
- Topic: DB2 QUICK START - FREE for Members
- Replies: 81
- Views: 154742
- Fri Feb 25, 2011 11:21 pm
- Forum: IMS DB
- Topic: How to Identify file name from DBD name
- Replies: 3
- Views: 7189
Anuj, I'm trying to update the IMS database such that my input records will be matched correctly with the database values and write the same in O/P file. The current scenario is my Pgm is not writing the records in O/P instead in Reject file. I need to correct this situation, so that my I/P records ...
- Mon Feb 07, 2011 9:52 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: Query using DELETE
- Replies: 6
- Views: 22027
- Sun Feb 06, 2011 10:00 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: Query using DELETE
- Replies: 6
- Views: 22027
Thanks Krishna !!!! I have changed LIKE to IN and the database have not been updated. Instead I tried to SELECT the database with IN and the query resultant is '0' rows, but the table has records. If I perform the same with single PRD_ID_DESC and 2 rows been fetched from my resultant query. Please a...
- Sat Feb 05, 2011 9:44 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: Query using DELETE
- Replies: 6
- Views: 22027
Query using DELETE
Hi, I need to update the database based on the list of Product details. My Table is defined as below Filed Name : PRD_ID_DESC Length : 50 The field comprises of Product ID (LENGTH - 6 CHAR) , some spaces, and Product desc. I have the list of Product ID (LENGTH - 6 CHAR) and I need to delete from tab...
- Mon Jan 31, 2011 10:57 pm
- Forum: IMS DB
- Topic: How to Identify file name from DBD name
- Replies: 3
- Views: 7189
How to Identify file name from DBD name
Hi, I'm struck up in finding the VSAM / OSAM dataset name for an IMS Database. I'm trying to edit the database for one particular filed manually in my Test environment, to complete test phase of my IMS code. Could you please guide me in right direction to identify the dataset name. Many thanks in ad...
- Tue Jan 25, 2011 11:15 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: How to Generate numbers Using SORT
- Replies: 2
- Views: 4524
- Sun Jan 23, 2011 11:38 am
- Forum: DFSORT , ICETOOL & Utilities
- Topic: How to Generate numbers Using SORT
- Replies: 2
- Views: 4524
How to Generate numbers Using SORT
Hi,
I have a requirement to generate numbers. I know the starting number and ending number, I need to generate this SORT, is this possible ?
Starting number is : 917000000000001
Ending number is : 917000999999999
Any help would be great !!!!
Thanks
I have a requirement to generate numbers. I know the starting number and ending number, I need to generate this SORT, is this possible ?
Starting number is : 917000000000001
Ending number is : 917000999999999
Any help would be great !!!!
Thanks
- Tue Jan 18, 2011 9:43 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: VSAM & DB2 Comparion
- Replies: 10
- Views: 12233
- Tue Jan 18, 2011 9:43 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: VSAM & DB2 Comparion
- Replies: 10
- Views: 12233
- Mon Jan 17, 2011 8:41 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: VSAM & DB2 Comparion
- Replies: 10
- Views: 12233
Thanks Krishna and Anuj !!!! Please find my answers: 1. Total size of data, based on Record size ( total no of records * total size ) - 1 million records and 1300 Record length 2. No of applications going to use this data concurrently - Probably less than 4 jobs will access this database concurrentl...
- Sun Jan 16, 2011 11:32 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: VSAM & DB2 Comparion
- Replies: 10
- Views: 12233
- Thu Jan 13, 2011 10:40 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: VSAM & DB2 Comparion
- Replies: 10
- Views: 12233
VSAM & DB2 Comparion
Hi, I need to load 100 million of records. I need to refer this database based on 3 basic keys from my input file. I need to load 100 million records as this is the first time to load with live data. Also this database will be refreshed on daily basis. Kindly can some tell me which is best suit to h...
- Sun Jan 02, 2011 10:27 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: Database RW,UTUT Error - S04E loading data
- Replies: 9
- Views: 22914
- Fri Dec 31, 2010 9:36 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: Database RW,UTUT Error - S04E loading data
- Replies: 9
- Views: 22914
Database RW,UTUT Error - S04E loading data
Hi, My job is trying to load DB2 table. When I try to load the database my job failed with S04E return code. When I check this, I found that the database is in RW,UTUT status. I have cleared this through TERM UTILID and the database was in RW status again. When I re-start the job again after some ti...