I have input file with three fields
Cust Id, Name, State
How do I load into target table with all the three fields into one field.
Target table is Customer
Field CustInfo (Cust Id + Name + State)
I am using Data Migrator 7.4 on HP Unix.
I haven't used data migrator, but you should be able to do a define or a compute. The field size needs to be equal to the sum of the three input fields plus 2.
DEFINE FILE yourfile
CUSTINFO/A200=CUST_ID||(' '|NAME)||(' '|STATE);
WF 7.6.8, AIX, AS400, NT
AS400 FOCUS, AIX FOCUS,
Oracle, DB2, JDE, Lotus Notes
Research how to use the Transformation Calculator. How to do concatenation is listed with that.
Data Migrator 5.3, 7.1, 7.6
WebFOCUS 7.1, 7.6, 7.7
SQL Server, Oracle, DB2
|Powered by Social Strata|