DSXchange

Dear Gurus, We have a requirement to read from a source which is basically JDBC. I know we can accomplish this using Java stage in Information server 8.1. However I don't see any options for JDBC. Also I couldn't find any document for JDBC connection. It would be really great if you could provide de...

After installing 32 odbc drivers onstead of 64 bit, datastage example binary is working fine. However from datastage client we are getting the following error message. DSR.MetaGeta(GET.DSNINFO)(SQLConnect('PG32','tstusr')): BCI Error: SQLSTATE=S1000,CODE=79,[DataStage][SQL Client][ODBC][OpenLink][OD...

We are using the one in Datastage [.odbc.ini]. We did not change anything in obbc.ini file under branded_odbc.

We did not find any trace log file under temp. Could you please let us know how to set this trace file.

yeah, we resolved that err now both the places we are getting the same err, there was some issues with DSN name we also tried all these drivers and result is the same -rwxrwxrwx 1 p139pkg ux_mdc 1901328 May 24 2007 pgr7_mt_lt.so -rwxrwxrwx 1 p139pkg ux_mdc 1945847 May 24 2007 pgr7_mt_lu.so -rwxrwxrw...

we also tried using the example binary using root with same result, i have copied the error below # example example DataDirect Technologies, Inc. ODBC Example Application. Enter the data source name : PostgresPG4 Enter the user name : tstusr Enter the password : tstusr SQLSTATE = IM002 NATIVE ERROR ...

yes, we have tried with chmod 777
still we have the same err..

ray.wurlod wrote:Have you checked that the executing user ID has sufficient permission to /home/p139pkg/odbc/source/lib/pgr7_mt_lt.so including "x" to the shared object itself? ...

we are trying to connect to a postgres 8.1 database from datastage using the openlink odbc drives and it says it couldnot load the drivers. we have the modified the .odbc.ini and make the required changes in uvodbc.config and dsenv file tried to restart the server after changing all the parameters. ...

Thanks for your replay. I have looked your link and got the following query. "select DS_JOBS.NAME JobName FMT '40L', DS_JOBOBJECTS.NAME LinkName FMT '30L', EVAL DS_JOBOBJECTS."@RECORD<12>" AS JobActivtyJobName FMT '40L' from DS_JOBOBJECTS, DS_JOBS where DS_JOBOBJECTS.OLETYPE = 'CJSJob...

When I was playing with dssearch command to search for Jobs used in a Specified Job Sequence, found there is a bug with this command. It is not listing all jobs under subsequences, when you are running subsequences parallel. Here is my out put. Stage\Sequence\LOSNew_seq, sequence job Shared\shr_job0...

Yes, you can write a routine, which internally executes the SQL server stored procedure through ODBC and get the results. It is very much possible.

Hi, We are getting the following error, when we are trying to delete *.ds files using orchadmin command. 0509-150 Dependent module liborchgeneralaix3.so could not be loaded. 0509-022 Cannot load module liborchgeneralaix3.so. 0509-026 System error: A file or directory in the path name does not exist....

Hi, I have created build op using C++ and able to open and close the file using "fsstream" class. However when I try to use "is_open" method of "fsstream", I am getting the compilation error saying "is_open" is not a member of "class fstream". But &q...

I would like to handle exception in build ops. If any exception the abort the job with custom error message (similarly like calling DSLogFatel function in basic routines).

I have seen "failstep()" macro in ds documents. Is this macro accepts the custom error message?.

Yes, I looked into directory log and job parameter values are coming correctly. I think the problem is with multiinstance. As you said we might have to remove multi-instance option. Thanks a lot. Welcome aboard! :D Look in the Director log in each case, to determine what value was used (supplied) fo...

Hi, we are using basic transformer for calling basic routine and passing job parameter as argument to the routine. This multiple instance job and job is aborting when we are running with invocation Id. However when we are running the same job through director without any invocation id, it is running...