DSXchange

Thanks for your response. I made the settings under decimal as Packed = Yes in the sequential file. So I thought the Sequential file has the capability to convert packed decimals. I could extract the data successfully when I have used the same setting to read another file in the past which has one r...

As you mentioned, the problem might be with the conversion of Packed and Binary data in the sequential file as I have taken the column with VARCHAR datatype. I tried using CFF stage becuase of this conversion of Packed and Binary data but there are issues with the record ID constraint with that stag...

Thanks for the information FranklinE.
I have tried with the settings you have mentioned above including the Record Type and no delimiter but still I am getting unreadable characters in the output.

I am deploying the jobs in another Environment to see if the problem is with the jobs or with the Environment before i put the blame on Oracle..Will update once i get some results. Thanks for replies

Seqfile Stage-->>Transformer-->>Lookup (reference as Oracle table)-->>Transformer-->>output(Oracle enterprise stage) reading an input fixed width field and trimming all of them about 20 columns and then do a lookup with a oracle table and then applying some transformations and then to get loaded to ...

Hello , I have problem running jobs on my DEV server which runs on UNIX, so i have enabled reporting ENV variables to know the issue. The jobs start normally and after that they hung up and will be on RUNNING state forever. In the job log i can see main_program: Starting Players. main_program: Waiti...

StringtoDate function expects the second argument as how the input date format is arriving and not how you want the output to look like.

So, instead of if Column='' then SetNull() else StringToTimestamp(Column:'00:00:00',"%yyyy%mm%dd %hh:%nn:%ss") I need to specify if Column='' then SetNull() else StringToTimestamp(Column:' ': '00:00:00',"%yyyy%mm%dd %hh:%nn:%ss") Tried the above but the job aborted with Fatal err...

I just tweeked with a peek stage and i have seen that the column is generating ******************* value. I have seen the input file and no value for that column has any such records

Can you please give your i/p and o/p formats..The question is not clear

See the below link
viewtopic.php?t=143297

It might help you to some extent

Hello there, I have a fixed width file coming with one of the field( Char(8) ) having a date format eg:20111122 and it has some empty values too.I have to load it to Oracle table as Timestamp which is NULLABLE and when i imported the table definitions to datastage it is imported as Timestamp with sc...

Thank you so much for the help James....

Thanks for your help Mike, That setting helped me to get the expected result. But in the output file, I could see a Decimal point ( . ) after the packed filed (Comp-3) in the result. The result looks like below for the last field (Packed filed) 1111115 . Can anyone help me to know the reason for thi...

StringtoDate would not work as that field is defined as Timestamp in the metadata for Oracle table. If you put StringtoDate and define the field as Timestamp it would not take it.And, if you define the datatype as Date...down the line again you need to convert the Date format to Timestamp format. I ...