rather than ftp ,is they any method to collect my files

[sunitha_cts]

HI,

My source is AS/400 WHERE DATA IS AVAILABLE IN FORM flat files ,is they any way to import the files into datastage ,i am using ultra edit for unix console ,so if i am using a hash file as the source ,how could i import as/400 files into datstage.

i was told to use chmod 777
convert dos to unix filename
dos numeric to filename in a discussion,CAN SOMEONE SUGGEST ME THE RIGHT WAY,to import my as/400 files into datastage for future applying the Etl.

Thanks
Sunitha

[ray.wurlod]

Use any utility (ftp, rcp, ODBC bridge for example) to move the flat files from the AS/400 to your DataStage server.

Once there, they can be processed with DataStage. If the data are encoded using EBCDIC there are functions in the SDK for effecting conversion of particular data types.

The move can be scripted, and the script executed under DataStage control, perhaps in a sequence or in a before-job subroutine.

[sunitha_cts]

Actually the files coming are moved to c:\documents and settings from AS/400 ,now our aim is to move the files throgh ultra edit into DS

[chulett]

So... what role exactly would UltraEdit be playing here?

[sunitha_cts]

The main aim is to move all the files and move them as folder ,this folder will have all the files i require

[chulett]

And you think you need UltraEdit to accomplish some part of that?

[sunitha_cts]

HI Chulett,

I was struggling with the ultra edit ,but finally I got the answer for ultra edit ,to check for the path manually we go for ultra edit we are directly passing job parameters in the job to fetch th file from AS/400.
Thanks
sunitha

[chulett]

OK, I guess I'll just step aside, then... here I was thinking you were asking about an automated solution. Ah well.