DSXchange

Thank You!!

Hi,
The DB has two instances with two different SID names.We connected to one of the instances.

Hi All,
The code got compiled successfully and we added DATASTAGE_JVM and DATASTAGE_JRE environmental vairables on the AIX server and the java function executed successfully using the java client stage on the job

Hi All, We are getting an error when we try to connect to Oracle using ODBC connector. [IBM(DataDirect OEM)][ODBC Oracle Wire Protocol driver][Oracle]TNS-12505: TNS:listener could not resolve SID given in connect descriptor I talked to DBA and the SID name is correct which we entered in odbc.ini. I ...

dsadm@ait-etl01dev:/home/dsadm $ env _=/usr/bin/env LANG=en_ZA.8859-15 LOGIN=dsadm SSH_TTY=/dev/pts/0 CLCMD_PASSTHRU=1 PATH=/usr/bin:/etc:/usr/sbin:/usr/ucb:/usr/bin/X11:/sbin:/usr/local/bin:/var/ifor:/usr/vac/bin:/usr/java5/jre/bin:/app/oracle/product/11.2.0/client_1/bin:/home/db2inst1/sqllib/java...

Hi, We are trying to invoke java function in datastage job. We tried to compile the code and we are getting same error like this post as seen below: generateUUID.java:1: package com.ascentialsoftware.jds does not exist import com.ascentialsoftware.jds.Stage; ^ generateUUID.java:2: package com.ascent...

I have gone through the connectivity to Stored Procedures guide before developing the job and as the documentation and our stored Procedure I assumed that our procedure type is a transform which is a mistake.I did not understand the connectivity guide completely.

The issue has been resolved after selecting the Procedure type as Source

I am currently executing the procedure as below: DECLARE @RC int EXECUTE @RC = CS_Interactions.dbo.cl_ica_dwh_customer_inquiry 10 I am leaving the parameters grid empty.When I run the job I am getting an error Stored_Procedure_0,0: Error: Wrong number or types of arguments in call to cl_ica_dwh_cust...

Hi All, We have a stored procedure that takes one input integer argument. dwh_interaction_history(X) where X is the number of days. When we load parameters from table definition, we are getting 2 parameters one ReturnValue (Function) and the other @last_days . In this case @last_days =X. We made Pro...

you say you wanted to include DB2 library path in dsenv, but in fact you didn't. What I see is an entry for DB2 binaries that is commented out. I'd expect an entry adding DB2 libraries to LD_LIBRARY_PATH. Sorry,I forgot to mention that they are commented now.Earlier we added them to LD_LIBRARY_PATH...

I don't see where you set the DB2 library path. Regardless, I'd make sure your LD_LIBRARY_PATH is all one line with no accidental returns in it. It may also be too long now and need to b ... We have edited the dsenv to have proper line breaks but still when we start the engine we are getting the sa...

Hi ulab,
The url shows the problem occuring during installation,But here we have installed and ran jobs properly before editing dsenv

Hi, We have edited the dsenv to add the DB2 library path and restarted the dsengine and then ASBAgent.When the ./uv -admin -start command is issued it finished with the error below DataStage Engine 8.7.0.0 instance "ade" has been brought up. Starting JobMonApp sh: module: line 1: syntax er...

I am writing a simple join query in ODBC connector stage as below: SELECT a.IP_ID, ltrim(rtrim(a.UNQ_ID_IN_SRC_STM)) as UNQ_ID_IN_SRC_STM_ID FROM vwIP_S a, vwSRC_STM_S b WHERE a.SRC_STM_ID = b.SRC_STM_ID And b.SRC_STM_CODE ='#p_SourceSystemCode#' #p_SourceSystemCode# is a job parameter and it has va...