 |
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 17 matches |
| Author | Message |
|---|---|
 Topic: query for no. of rows with a column value ending with x'00' |
|
| mayuri Replies: 8 Views: 3910 |
 Forum: Database Posted: Wed Apr 11, 2007 5:51 am Subject: query for no. of rows with a column value ending with x'00' |
| hi all,
thanks for your responses. firstly i would like to apologize for the reason that the output of my second query is not 142 but zero. anyways the first query is the correct one. Regards ... |
|
| Topic: query for no. of rows with a column value ending with x'00' |
|
| mayuri Replies: 8 Views: 3910 |
Forum: Database Posted: Mon Apr 09, 2007 9:38 am Subject: query for no. of rows with a column value ending with x'00' |
| hi all
i have got one more query on LIKE search. i have few rows where " is present in one of the column value. i have queried as follows select count(*) from table where column like '%" ... |
|
| Topic: query for no. of rows with a column value ending with x'00' |
|
| mayuri Replies: 8 Views: 3910 |
Forum: Database Posted: Tue Mar 27, 2007 12:19 am Subject: query for no. of rows with a column value ending with x'00' |
| hi all,
i got it with the following query: select count(column) from table where RIGHT(column,1) = X'00' also the query given by Kolusu. Thanks dbzTHEdinosauer and Kolusu for your inputs. R ... |
|
| Topic: query for no. of rows with a column value ending with x'00' |
|
| mayuri Replies: 8 Views: 3910 |
Forum: Database Posted: Sat Mar 24, 2007 7:48 am Subject: query for no. of rows with a column value ending with x'00' |
| hi all,
A DB2 table column has a value like ABCD QWER. when i extracted this value and wrote into a file it was written as ABCD QWER only. The . is actually x'00' and i found this by doing HEX ... |
|
| Topic: DB2 COMMIT |
|
| mayuri Replies: 11 Views: 7438 |
Forum: Database Posted: Sat Mar 24, 2007 7:15 am Subject: DB2 COMMIT |
| I'm doing an auto commit. | |
| Topic: DB2 COMMIT |
|
| mayuri Replies: 11 Views: 7438 |
Forum: Database Posted: Fri Mar 09, 2007 1:35 am Subject: DB2 COMMIT |
| hi All,
I have a question regarding commit and rollback. My application queries DB2 table and fetches around 100K of rows each time. i need to take each row's data and write into a sequential file. ... |
|
| Topic: Query regarding CA7 Scheduler |
|
| mayuri Replies: 9 Views: 7156 |
Forum: Job Control Language(JCL) Posted: Tue Dec 05, 2006 7:30 am Subject: Query regarding CA7 Scheduler |
| hi Kolusu
Thanks a lot for the information i have implemented in the same way..(combining the two jobs) Regards Mayuri |
|
| Topic: Query regarding CA7 Scheduler |
|
| mayuri Replies: 9 Views: 7156 |
Forum: Job Control Language(JCL) Posted: Sat Dec 02, 2006 1:10 am Subject: Query regarding CA7 Scheduler |
| hi kolusu,
i have one more doubt also. if i combine JOBA and JOBB as follows FINALJOB STEP1:does JOBA STEP2:does JOBB if STEP1 fails then FINALJOB will completely fail.. right? i donot have ... |
|
| Topic: Query regarding CA7 Scheduler |
|
| mayuri Replies: 9 Views: 7156 |
Forum: Job Control Language(JCL) Posted: Fri Dec 01, 2006 11:40 pm Subject: Query regarding CA7 Scheduler |
| Kolusu
yaa i can do that. but please tell me the advantages and disadvantages of combining two jobs for my case in particular and also in general.. Thanks in advance Regards Mayuri |
|
| Topic: Query regarding CA7 Scheduler |
|
| mayuri Replies: 9 Views: 7156 |
Forum: Job Control Language(JCL) Posted: Fri Dec 01, 2006 12:35 pm Subject: Query regarding CA7 Scheduler |
| hi Kolusu,
thanks for your quick reply. i want to tell you few more things JOBA will dynamically open(using PUTENV) the sequential files which were pre- allocated. so say 4 sequential files we ... |
|
| Topic: Query regarding CA7 Scheduler |
|
| mayuri Replies: 9 Views: 7156 |
Forum: Job Control Language(JCL) Posted: Fri Dec 01, 2006 8:12 am Subject: Query regarding CA7 Scheduler |
| hi all,
i have two jobs. JOBA will extract data from DB2 and puts them into sequential files. JOBB will FTP these files to windows environment. JOBB has to run immediately after JOBA completes. a ... |
|
| Topic: In between space - PL/1 |
|
| mayuri Replies: 10 Views: 5831 |
Forum: Application Programming Posted: Fri Nov 17, 2006 9:37 am Subject: In between space - PL/1 |
| oh..im so sorry..i havent noticed that.. | |
| Topic: question regarding BLOB storage utilization |
|
| mayuri Replies: 1 Views: 1343 |
Forum: Database Posted: Fri Nov 17, 2006 6:04 am Subject: question regarding BLOB storage utilization |
| hi
hope this link helps you http://www.dbazine.com/db2/db2-mfarticles/mullins-lobs Mayuri |
|
| Topic: In between space - PL/1 |
|
| mayuri Replies: 10 Views: 5831 |
Forum: Application Programming Posted: Fri Nov 17, 2006 4:17 am Subject: In between space - PL/1 |
| hi Bauer,
you can try this. Compute the length of the input string into WS-LENGTH PERFORM VARYING WS-I-CNT FROM 1 BY 1 UNTIL WS-CNT> WS-LENGTH IF WS-INPUT(WS-I-CNT:1) NOT = SPACE ... |
|
| Topic: sqlcode 180 during fetch |
|
| mayuri Replies: 4 Views: 3314 |
Forum: Database Posted: Thu Nov 02, 2006 11:08 pm Subject: sqlcode 180 during fetch |
| hi Kolusu
The Timestamp fields are NOT NULL Regards Mayuri |
|
All times are GMT - 5 Hours |