OraFAQ Forum: Other Operating Systems » PRO COBOL SQL problems galore

Home » Infrastructure » Other Operating Systems » PRO COBOL SQL problems galore

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

PRO COBOL SQL problems galore [message #161062]

Wed, 01 March 2006 18:39

MiamiVice
Messages: 2
Registered: March 2006
Location: Miami

Junior Member

Howdy all.

We are Installing Peoplesoft here, in the conversion stage at the moment.

We are using PRO COBOL to load data from a flat file to an ORACLE staging table, which is then thrown out to Peoplesoft tables.

Anyway, i am not having fun with PRO COBOL.

I see my INSERT statement (which inserts 111 fields into a single table) gets converted/generated at run time.

I am seeing very basic non descriptive error messages, and no reference to a particular field where the error is.

I see that SQLERRD(5) holds the offset of the character position at which the error begins, but it seems to me this is within the GENERATE SQL statement, which i cannot see.

How do i see the generated SQL statement ?

Any help much appreciated.

Thanks

Report message to a moderator

Re: PRO COBOL SQL problems galore [message #161133 is a reply to message #161062]

Thu, 02 March 2006 03:43

orausern
Messages: 826
Registered: December 2005

Senior Member

dont know answer to your pro cobol related question, but one question I got is: why did you decide to use pro cobol?
To migrate text data into oracle, there is sql loader isn't it?

Report message to a moderator

Re: PRO COBOL SQL problems galore [message #161171 is a reply to message #161133]

Thu, 02 March 2006 06:47

MiamiVice
Messages: 2
Registered: March 2006
Location: Miami

Junior Member

Believe me, i have been asking myself this question ever since i started to write my first PRO COBOL program !

I was directed this way, saying it was site standard.

We do have a bunch of Translate tables sitting on the ORACLE side, translating the Legacy data into Peoplesoft data as we go etc. Not an SQL LOADER expert, but dont think you can do that in SQL LOADER.

Report message to a moderator

Re: PRO COBOL SQL problems galore [message #161174 is a reply to message #161171]

Thu, 02 March 2006 06:59

orausern
Messages: 826
Registered: December 2005

Senior Member

The decision of which tool you use for migration is a key decision!

If i understood right, you have flat files from which you get the data into oracle? in that case sql loader is a tool , that one would recommend. see its documentation at:
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96652/part2.htm#436160

Of course you can do a comparative analysis with some other tools as well..if you have oracle support,may be you can interact about this with oracle as well.(on oracle metalink site)

also migration related links you can refer at:
http://www.oracle.com/technology/tech/migration/index.html

(though they are for migrating data from one database like access etc to oracle,whereas you have flat files)

Report message to a moderator

Previous Topic:	Accessing Oracle (Unix based) from z/OS CICS transactions
Next Topic:	backup and restore for MVS ?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jan 07 10:57:32 CST 2025