DSXchange

Hi, I am working with ibm information server 8.1. In a parallel job, when I execute a user defined query from an oracle enterprise stage, if the query returns rows there are no problems. If the table from which I am extracting records is empty, the view data returns the error VIEWDATA ROW LIMITER HI...

ray.wurlod wrote:

Code: Select all

Errcode = SQLError(hEnv,hDBC,hStmt,SQLState,DBMScode,LastErr)

Details are to be found in the UniVerse BASIC SQL Client Interface manual. ...

Thanks for the answer

That's just SQL.ERROR. You have to call SQLError() repeatedly to strip the error information off the handle, to learn precisely what went wrong. ... I did like this: * THIS DOESN'T WORK, status <> SQL.SUCCESS status = SQLConnect(hdbc,DNS_NAME,ODS_USER,ODS_PWD) if status <> SQL.SUCCESS then Ans = SQ...

Please, can you tell me how to use the SQLError function ? Which are the parameters ?
Thanks fo helping me

Angelo.

ray.wurlod wrote:That's just SQL.ERROR. You have to call SQLError() repeatedly to strip the error information off the handle, to learn precisely what went wrong. ...

Please, can you tell me how to use the SQLError function ? Which are the parameters ?
Thanks

Hi Friends, Please Help in the below warning, its occured in my job REPORT: When checking operator: When binding input interface field "COUNTRY_CODE" to field "COUNTRY_CODE": Converting a nullable source to a non-nullable result; a fatal runtime error could occur; use a modify o...

chulett wrote:What is the status it actually returns? ...

The status is -1

I am trying to execute a select statement from a datastage server routine. It was ok and was working on datastage 7.5 but now, on 8.1 version it doesn't work. The parameters that I pass to the SqlConnect function are correct, they work on 7.5 version. Thanks a lot for help... This is the code: $INCL...

Thanks to everybody for suggestions, i will try and let you know...
Angelo.

Thanks to everybody for suggestions, i will try and let you know...
Angelo.

Hi, I have 2 questions and hope that some of you has already met this kind of problem 1. How can a sequencer job of datastage wait for a file that always change his name. For example I receive sequential files from a system that give me files named with the creation date and an id, like this: filena...

chulett wrote:Perhaps this (rather long) thread might have the info you are looking for?

viewtopic.php?t=115619

OK, thanks a lot, I will try...

Its again one and the same. To write a procedure where you do all the necessary calls and loads. Extract the loaded temp table to datastage via OCI stage and pass it through the transformer and load i ... Please, if you know how, can you tell me how can I get the result of the query and return it f...

Ugh. Why do all that when a simple job with an OCI or ODBC stage will easily do the same thing? ... Because the simple select that you see is just an example, but I have to do a more difficult thing. I have an oracle package that does a lot of calculation depending on the parameters that I pass to ...

I made the following transform function in datastage that execute an oracle query. It works, but I don't know how to catch the result of the query. In this case it should be the system date. Please can you help me ? Thanks to everybody... RoutineName = 'ExecOracleStatement' henv = SQL.NULL.HENV hdbc...