I m converting a EBCIDIC file into the fixed width ASCII file ,but i m not able to view data in the source stage itself , how can i convert the above file ?
How are you reading the data as? I mean which format? Irrespective of "View Data" would you able to run the job without any error? Hope you are using Transformer to convert to Ascii.
By the way, why was the restriction?
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
Ya, i m using transformer to convert the data(but the transformer is holding the direct move)
I m able to run the job but the data is not actually converting,the source file is fixed width.
kamaldeep.kaur wrote:but i have restriction to use only Sequential file stage for the source.
Always push back on (that is, resist) insane requirements. Demand justification. Would they expect you to tighten screws with a spanner? You have the right tool; insist upon the right to use it. It's not as if it's not in the toolbox.
Last edited by ray.wurlod on Wed Mar 14, 2007 6:17 pm, edited 1 time in total.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
If your truely on PX then in sequential file stage, under format tab, you have Type defaults. Under type defaults you have String. String has a property Export EBCDIC as ASCII. Look into that. This property will enable you to read a binary file via sequential file stage.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.