Page 1 of 1
Use PS to access flat file
Posted: Mon Aug 28, 2006 10:36 am
by pneumalin
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!
Posted: Mon Aug 28, 2006 8:28 pm
by ray.wurlod
No problem whatsoever. The training class uses flat file exclusively (for portability reasons).
Posted: Tue Aug 29, 2006 1:33 am
by pneumalin
Ray, thanks for the help! It boosts the confidence to work with this product.
Posted: Thu Aug 31, 2006 11:34 pm
by pneumalin
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!
Posted: Fri Sep 01, 2006 2:42 am
by ray.wurlod
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.)
Posted: Fri Sep 01, 2006 7:32 am
by pneumalin
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.