Unconfigured Ad Widget

Collapse

Announcement

Collapse
No announcement yet.

Analyze DB2/400 Data with Excel

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Analyze DB2/400 Data with Excel

    ** This thread discusses the article: Analyze DB2/400 Data with Excel **
    ** This thread discusses the Content article: Analyze DB2/400 Data with Excel0

  • #2
    Analyze DB2/400 Data with Excel

    ** This thread discusses the article: Analyze DB2/400 Data with Excel **
    I have used the ls function to go from the PC to the I series during some conversion efforts . the biggest problem I have run into is the in ability to mass change the cell contents to a specific format. the transfer from pc to as400 requires that the data within a cell meets the criteria of the dds on the as400. columns defined as general default to text and will fail if the cell contains a numeric number. the will abort the transfer. How can you resolve this problem. I have used the .prn output from exel and have FTP'd these files to the 400 then redifined the fields on the 400 to get around this problem which is a real pain.

    Comment

    Working...
    X