Packed data

tjmeichen · Post by **tjmeichen** » Thu Jul 03, 2003 9:12 am

I am trying to FTP packed data from an OS/390 system to Data Stage 6.0. I keep getting an error that I have a mismatch number of columns between my data and my link. I used a cobol layout for my meta data. What do I need to declare my fields as for data type? I have tried several different types and I get the wrong or no data. The file does have character data in it as well.

tonystark622 · Post by **tonystark622** » Thu Jul 03, 2003 10:41 am

You may find a recent thread helpful.

Good luck!

Tony

tjmeichen · Post by **tjmeichen** » Thu Jul 03, 2003 11:38 am

From what I read on the recent thread, the responses appear to be from after the data is FTP'd to the server. I need to know how to get the data in its native form over to the server.

tonystark622 · Post by **tonystark622** » Thu Jul 03, 2003 11:56 am

Are you doing the FTP in a DataStage job (in an FTP stage)? Or in an external process? It might be better to FTP the job over outside DataStage, then try reading the file and converting it. There are some options in the metadata that allow DataStage to ignore incomplete fields and rows... That also might be helpful.

Good Luck,
Tony

cwong · Post by **cwong** » Thu Jul 03, 2003 12:02 pm

One quickie attempt is to check whether you have binary mode on before get/put file, i.e. type I [^]

cwong

ray.wurlod · Post by **ray.wurlod** » Thu Jul 03, 2003 4:52 pm

This is the kind of task that the MetaRecon product performs. It profiles data not by looking at the metadata but by looking at the actual data and inferring what the metadata should be. Find out more from the Ascential web site, or contact someone in Ascential, or visit the sister site of this one (www.datastagexchange.com) and check out the Forums there.

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518