comp.sys.ibm.as400.misc - IBM AS/400 miscellaneous topics.
Hello all, I would like to import a comma separated values file to DB2 UDB 8.2. This file also contains values of type DATE and TIMESTAMP having for example the following format 900925 033701.0000 (yyMMdd HHmmss.ffff). For the import, I right-click on the table -> Import and then choose the file with file type "DEL" and confirm the mapping given in "columns". But as result, I get that all rows are refused. Could I somewhere find more detailed information WHICH column causes the problem? With trying out and leaving away different columns, I found out that the error comes from the DATE and TIMESTAMP column, but is there a possibility to find it out directly after getting the result that rows are refused? I think that "my" DATE and TIMESTAMP columns cound not be inserted because of the format. How could I tell DB2 which format my date have? Is there anything like DTS for MS SQL Server 2000 also for IBM DB2? Would be glad if anybody could help me in this topic. Cheers, Ina
All - I am trying to figure out how to get a comma delimited file from the command line which includes the column headings as the first line. I know how to create a del file using export, but it doesn't put the headings. I also know I could redirect the output from a select, but a select isn't comma delimited... Any ideas?
Anyone have a tool to do this, I don't have iseries access license.
I have a land file downloaded from the property appraiser's web site as a .csv file, that I can open in excel. I've tried exporting to text but nothing lines up. I've tried importing from csv into access and sql server, but the file I get on my AS400 after I transfer it with client access has some type of tabs or something between fields, and the AS400 gives a message that data is invalid and it will not even read it. How would you go about getting a file of names, addresses, parcel codes, etc. from my PC into an AS400? Thank you in advance for your help, Joe in Florida