Use PS to access flat file

pneumalin · Post by **pneumalin** » Mon Aug 28, 2006 10:36 am

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!

ray.wurlod · Post by **ray.wurlod** » Mon Aug 28, 2006 8:28 pm

No problem whatsoever. The training class uses flat file exclusively (for portability reasons).

pneumalin · Post by **pneumalin** » Tue Aug 29, 2006 1:33 am

Ray, thanks for the help! It boosts the confidence to work with this product.

pneumalin · Post by **pneumalin** » Thu Aug 31, 2006 11:34 pm

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!

ray.wurlod · Post by **ray.wurlod** » Fri Sep 01, 2006 2:42 am

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.)

pneumalin · Post by **pneumalin** » Fri Sep 01, 2006 7:32 am

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.