All Forums Tools
TS 12 posts Joined 02/06
22 May 2006
Loading Data from a file recieved from Mainframes

Hi,We need to load data into TD tables using the file we recieve from Mainframes. But the file which we receive from mainframe contains the data in packed integers and packed Decimals, i.e. in Binary and EBCDIC format due to which it cannot be loaded using MLOAD utiliy.The same file is easily read by DB2 directly without any conversion but for TD we are facing problem.So we need to first convert the file using some COBOL program into a TD readable format, which is then loaded using MLOAD.Is there any way using TD tools and utilities, that we convert the file and load it?Thanks in advance.Regards,Tanu.

DGiabbai 47 posts Joined 07/04
22 May 2006

While reading the documentation for Multiload "Run-Time Parameters" I've found that a run-time parameter is "CHAR SET=VALUE" for channel attached systems (or "-c VALUE" for network attached systems).Read more about it to see if it would fulfill your needs.

TS 12 posts Joined 02/06
24 May 2006

Thanks a lot for the help!But the problem is still not solved, actually the TD is on network-attached, so when we get the data file from MVS system on the staging server it is converted in a format which is readable by the TD system using some program. If the data file is in the EBCDIC format(the one which is extracted from MVS), i.e. if it is not converted in the format readble by TD then even on using the ch****t runtime parameter for mload the records are being rejected.If any help can be provided, it would be great.Thanks & Regards,TS.

Fred 583 posts Joined 08/04
24 May 2006

Teradata utilities expect input data to be in a "native" format for the platform on which the client is running. So mainframe format data is handled nicely when your Teradata system is channel-attached. Or if the data was in some "portable" format such as delimited text, then network-attached utilities could handle it. But there's no built-in support for loading mainframe-format binary data records from a UNIX or Windows server.You could write INMOD / AXSMOD on the client side or UDFs in Teradata to do specific conversions...

TS 12 posts Joined 02/06
25 May 2006

Thanks a lot for the inputs!!Regards,TS.

You must sign in to leave a comment.