MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Search found 3 matches
MVSFORUMS.com Forum Index
Author Message
  Topic: How to convert Hexadecimal to Decimal
thomas

Replies: 1
Views: 9395

PostForum: Database   Posted: Tue Apr 04, 2006 6:10 am   Subject: How to convert Hexadecimal to Decimal
Hi,

Is there any function available in DB2 Z/OS for converting Hexadecimal to decimal. Or any other way we can do it ?

Thanks
  Topic: How to Run SQL in Batch
thomas

Replies: 3
Views: 1964

PostForum: Database   Posted: Fri Mar 10, 2006 7:27 am   Subject: How to Run SQL in Batch
Hi Kolusu,

Thanks for your response ..

I want to execute a UPDATE Statement using DSNTEP2 and my search condition is in dataset TMC001.CUST.DATA , which having around 5000 record .

Just hav ...
  Topic: How to Run SQL in Batch
thomas

Replies: 3
Views: 1964

PostForum: Database   Posted: Fri Mar 10, 2006 4:24 am   Subject: How to Run SQL in Batch
Hi ,

I have data set TMC001.CUST.DATA , which having around 5000 custno . How to run the SELECT SQL in Batch using this dataset as 'in set'

ie select * from customer where custno in ()


...
 
Page 1 of 1
All times are GMT - 5 Hours
Jump to:  


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group