Re: Where to find syntax for ODBC commands

Note: When creating the function in postgres, declared the parameters as in out .

ln_SQLResults = SQLEXEC (Handle,  "{CALL DeuJob.UpdateAccounts (?tn_MachineID,?@ll_Status)}")

should change to (assuming tn_machineid and ll_Status are foxpro variables (must be declared private or public)

In_SQLResults = SQLEXEC (Handle,"select * from DeuJob.UpdateAccounts(?tn_MachineID,?ll_Status) “,”CCoutputcursor” )

(You will find 2 fields in the ccoutputcursor called tn_machineid and ll_status

ln_SQLResults = SQLEXEC (Handle, "{CALL DeuJob.Unduplicate ({resultset 4, p_DupJobs})}", 'deu_cur_job')
where p_DupJobs is an Oracle TABLE OF VARCHAR2

should change to (not sure what “Resultset 4” does, but no need for result set or “Table of varhchar2), in fact, the oracle “Table” function in used or needed in Postgres

ln_SQLResults = SQLEXEC (Handle,"select * from DeuJob.Unduplicate(4,?p_DupJobs)”, "deu_cur_job")

Be sure to declare the function parameters as “In out” and as type “Any”(Postgres is strong typed and numeric, integer etc may need different definition unless you declare the parameter as “any type”

Thanks

Barry Bell, IT Department

Office: 954-429-3771 x267 Fax: 954-281-1464 email Barry_Bell@harte-hanks.com

From: Christine Jorgensen [mailto:222mooney@gmail.com]
Sent: Tuesday, June 05, 2012 11:47 AM
To: Barry Bell
Cc: pgsql-odbc@postgresql.org
Subject: Re: [ODBC] Where to find syntax for ODBC commands

Thank you, Barry.
The current code is
ln_SQLResults = SQLEXEC (Handle, "{CALL DeuJob.Unduplicate ({resultset 4, p_DupJobs})}", 'deu_cur_job')
where p_DupJobs is an Oracle TABLE OF VARCHAR2
The procedure returns a maximum of 4 entries into the deu_cur_job cursor.

So the new code should be:
ln_SQLResults = SQLEXEC (Handle,"select * from DeuJob.Unduplicate", "deu_cur_job")
Is that correct?

and

ln_SQLResults = SQLEXEC (Handle,  "{CALL DeuJob.UpdateAccounts (?tn_MachineID,?@ll_Status)}")

should change to

n_SQLResults = SQLEXEC (Handle,"select * from DeuJob.UpdateAccounts", "tn_MachineID, ll_Status")

I will play with this and see what happens.

How do you figure this stuff out?  The psqlodbc documentation does not mention any of this.

Thank you,
Christine