DSXchange

HI ,I need to get the timestamp from current time in GMT format.could you please help me with this function .can I use this function CurrentTimestampMS()..
to get first 7 digits

Thank you
Sri

the version 8.5.0.1. I tried with regular xsd. it worked fine. the one that is not working is chronological xsd.

Thanks

Hi, I tried to import xsd via 8.5 Assembly editor.i got below error message src-resolve: Cannot resolve the name 'ns10:Interchange' to a(n) 'type definition' component. schema_reference.4: Failed to read schema document '../common/FinancialInformation.xsd', because 1) could not find the document; 2)...

all fileds are defined as char. I need to conver from char and integer and get the max

Thanks

Thanks chulett. I tried with max, but it is giving all zeros. do I need to take other things into consideration

thanks

sorry, my data is not looking correct

** abc 10.25 - this is first record for col1, col2 and all cother columns have spaces
$$ def 11.9 - this is second record for col 4, col5 and col6 and all other columns have spaces
## ghi 10.4 - this is third record for col7,col8 and col9

Thanks
Sri

Hi, Can you please advice me how to achieve below logic my source data is like this key1 key2 col1 col2 col3 col4 col5 col6 col7 col8 col9 1111 2222 ** abc 10.25 1111 2222 $$ def 11.9 1111 2222 ## ghi 10.4 output should be like this key1 key2 col1 col2 col3 col4 col5 col6 col7 col8 col9 1111 2222 **...

Thanks Ray.it worked

I did check the file in UNIX.
KEYING VARIANCE MESSAGE TO SEE WHAT LOOKS LIKE ON INVOICE. KEYING ^Z REALLY LONG FIRST LINE. PLEASE PAY THE FOLLOWING ADJUSTMENTS:

there is ^Z character instead of ^M.what is ^Z

Thanks

do i need to use any convert function or something like that to get unix line character in string

Thank s ray. I am using basic transformer in paralle job Now i can write to the seq file KEYING VARIANCE MESSAGE TO SEE WHAT LOOKS LIKE ON INVOICE. KEYING ?REALLY LONG FIRST LINE. PLEASE PAY THE FOLLOWING ADJUSTMENTS: now i need to read this into multiple lines and write to the table. i tried with U...

HI Ray, Thanks for your reply. I need to split the long line into multiple lines and write these to table records Based on your input my idea is write this to sequential file adding some delimiter between these and read the input file by delimiter I did like this. I added new line feed after every 7...

Hi, I need to be able to split large string variables into multiple lines, each line can be no longer than 70 chars. The string variables are text, so I would additionally like the lines to end at the end of a word Now, with a limit of 70 chars per line (and lines *must* end with a completed word) e...

Thanks Ray for your suggestion. I will start working on taht

Thanks

Hi HI, I am getting data from sybase table like this. whole line as one record STATMENT. ^M ^M NEXT STATMENT. ^M^M THANK YOU there are new line characters between these statments.before I load the data into oracle table, I need to split this one record to 3 records , each on separte line. can you pl...