Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
? accessing timestamp field from Oracle via Oracle DB2 Gateway
Here is an idea of what I am trying to do. The create_dt in the db2 is defined as timestamp field and contain a value such as: 2002-05-28-07.31.09.319006 The create_dt field is indexed and I would like my query to use the index, otherwise I could substr the date and just pick up the date and... -
does any one have a sample
Thank you so much Cakiwi and Marsd.... I was messing up the if statement. I got it working now. Lebond -
does any one have a sample
The XXX and YYY values change with each header line. I have tried to code an if statement and substr the values from the line to the end of the line but nothing is working for me. Any other input would be greatly appreciated. Thanks LEBOND -
does any one have a sample
I want to read a file, if I find a line with a business unit=XXX, Responsibility=YYY, I want to add XXXYYY to the end of the line. I want to output file to be in the same order as the input file and not alter any of the other lines, just the headers that will have different business unit and...
