Can we take the file with the tilde and transfer it to the AS400 as is, or should the file be converted to a fixed width? The AS400 engineer told me that the file needs to be converted to a fixed width.
The environment consists of SQL Server 2005, Visual Studio 2005, and AS400. The tilde delimiter file is set by the external source as is. We are trying to take this file and get it in AS400 to process purchase orders.
Below is an example of the file that we need to transfer to the AS400. The initial thought was to convert to a format that SQL Server can read, split into different tables into groups, i.e. PROCESSPO, PO, and LINE, so that we can correctly define the columns. Then create the files, in this case 3, for the developer channel in the AS400. There will always be 5 different types of records, but I provide only 3 types of records, because this is all the data I have to work with.
PROCESSPO ~ TP-4186 ~ CARQUEST ~ ALLTRADE ~ 1.2 ~ 2011-04-06T13: 24: 45.000-07: 00
PO ~ TP-4186 ~ TP-4186 ~ 2011-04-06T13: 24: 45.000-07: 00 ~ TR-13824 ~ TR-13824 ~ 1 ~ 0 ~ RAL ~ Raleigh DC ~ 2635 Millbrook Road ~~~ Raleigh ~ NC ~ 27604 ~ US ~ 555-555-5555 ~ 177200 ~ DCS Raleigh Store ~ 2635 Millbrook Road ~~~ Raleigh ~ NC ~ 27604 ~ US ~ 555-123-4567 ~
LINE ~ TP-4186 ~ 1 ~ TP-4186 ~ 430937 ~ TLS ~ 1.0 ~ EA ~ FEDGRD ~ ALLT_LB ~ Alltrade Tools LLC ~ 1431 Via Plata ~~~ Long Beach ~ CA ~ 90810 ~ US ~ 310-522-9008 ~
Since I don’t know AS400, I don’t know how this will happen in this data, but I spoke with different resources that say they can receive Excel tables, but are not sure how they will read the data, because they only worked with spreadsheets with a fixed number of columns across the board. I also pinged the Stackoverflow community for the same reason.
AFTER THE AS400 DEVELOPER CHECK, IT RESOLVED THAT ONE FIXED WIRELESS FILE HAS BEEN A PERFECT DECISION, BUT THIS WASN'T REQUIRED MORE THAN A LITTLE DESIRE, THAN MUCH MORE. I CREATED MULTIPLE FILES AND ITS DATA SUBMISSION DIRECTLY FOLLOWING IN AS400 FROM VISUAL STUDIO 2005. THANKS FOR ALL YOU FEEDBACK.
Wence