Hi All,
Just to confirm with whoever is experienced in accessing flat file using PS! Has anyone successfully configured the Data Direct ODBC driver to access CSV file from PS? I know there is no problem to access the XLS like a table using ODBC, how about the flat file(CSV, fix-length,..)?
Thanks for your help!
Use PS to access flat file
Use PS to access flat file
Pneuma Lin.
pneumalin@yahoo.com
pneumalin@yahoo.com
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Ray, thanks for the help! It boosts the confidence to work with this product.
Pneuma Lin.
pneumalin@yahoo.com
pneumalin@yahoo.com
Ray,
I got an error when Browsing Source of CSV file in PS :
String[1128]-2006-09-02 01:24:16
3704 - Operation is not allowed when the object is closed.
String[1107]Menu item 41
String[1165]ADODB.Recordset
I did:
1. define MCIROSOFT ODBC txt,csv driver System DSN to access directory containing all CSV files.
2. Perform "Load database metadata" to import folder as database.
3. I am able to "Select a database" and Initialize the fileDSN DB .
4. Try to Browse Source of one of the CSV and get the above error.
Appreciate it if you shed some light on it! Thanks!
I got an error when Browsing Source of CSV file in PS :
String[1128]-2006-09-02 01:24:16
3704 - Operation is not allowed when the object is closed.
String[1107]Menu item 41
String[1165]ADODB.Recordset
I did:
1. define MCIROSOFT ODBC txt,csv driver System DSN to access directory containing all CSV files.
2. Perform "Load database metadata" to import folder as database.
3. I am able to "Select a database" and Initialize the fileDSN DB .
4. Try to Browse Source of one of the CSV and get the above error.
Appreciate it if you shed some light on it! Thanks!
Pneuma Lin.
pneumalin@yahoo.com
pneumalin@yahoo.com
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Try using the Ascential-supplied ODBC text driver.
And/or make sure that the ODBC DSN is configured with the correct format option (e.g. CSV, first line is header, etc.)
And/or make sure that the ODBC DSN is configured with the correct format option (e.g. CSV, first line is header, etc.)
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Ray, Thanks! I resolved my problem right before your posting. The Ascential Text Driver resolves the problem. By the way, PS 7.5.1.A includes the features to Load Meta Database from COBOL CFD and Sequential file. I believe there is no such thing in 7.0. and I heard people used MetaBroker to load the Meta Data to PS from DataStage Table definition imported from COBOL CFD or PL/I. Thought it is good to know.
Pneuma Lin.
pneumalin@yahoo.com
pneumalin@yahoo.com