DSXchange

Yes I did. But please let me understand what that has to do with the parameter sets? I don't even have the schema name parametrized.

Thanks, we are using parameters sets, but I can see in SQL statements that there is no where schema name is passed as parameter. For testing purpose we have created a test project and done the full project import and then when I do the view data it is pointing to the right schema. Just for the Note:...

Hi all, can anyone please let me know how does the schema name gets passed to DB2 UDB API stage? In the userdefined SQL query there is only table name mentioned but when I export the job as XML and checked it's showing up as "DW\.Table name". I understand for the ODBC driver you set the Al...

Thanks so much, because of your suggestions I started debugging if it could be the CLI function SQLExecDirect error. Finally we find that we are having ODBC Driver issue. In the advanced tab of the driver we found that for Alternate ID there is no default schema mentioned, after correcting that ever...

That would not be the case. I have ran the query in rapid SQL and it returned the result. I am having this issue with all the routines which are using the Db2 Connection.

I tried searching the issue but I wasn't able to come up with any info. If I missed please direct me. When I am running the Job sequencer which is using a user Defined routine, the job sequencer is getting aborted with the Routine warning. SQLExecDirect STATUS-Select = -1 SQLSTATE= 00000 dbmscode=-1...

Hi all, I am trying to extract data from a Cluster table in SAP and the requirement is that I join this table with two other tables and get the data. Since it is a cluster table I choose the option "Build SQL query" while generating the ABAP code. Issue: I was not able to join the Cluster ...

Hi, while we are calling the mainframe cobol program (stored procedure) we got the Fatal error mentioning "Error occurred in call to ORPHCallActivePluginTerminate()" . can any one please let me know why we would get this error. Please let me know if you need more details. I searched the fo...

Hi all,

Could any one please let me know if there is any time limit that datastage has when it calls SQL server stored procedure.

We are calling Stored procedure using DRS stage in Before tab. So I was wondering how long could the datastage wait to complete the SP.

It resolved when i made the non-key columns as keys in datastage to update the table.

Hi, I wrote a custom SQL in DB2 stage, in which i am updating two columns based on two other non-key columns Job design is dataset --> Transformer -- > DB2 API stage. I am getting following error, is it because i am using non-key column to update the table? DBMS.CODE=-99999, SQLSTATE=07006, [IBM][CL...

Can you try this. Sort the keys and create following stage variables. StageVar1: If JMKCOO:JMDOCO:JMDCTO:JMLNID <> Stage Var2 then JMTXLN Else Stage Var3 : JMTXLN Stage Var2: JMKCOO:JMDOCO:JMDCTO:JMLNID Stage Var3: Stage Var1 Then assign Stage Var3 to your output column and capture the last row in t...

Stage Var1: String[18,2] Stage Var2: When Stage Var2 = 'PM' and string[9,2] = '12' Then '12' Else If Stage Var2 = 'PM' Then '12+string[9,2]' Else string[9,2] Stage var3: String[1,4]:'-':string[5,2]:'-':string[7,2]: ' ':Stage Var2: String[11,6] Column derivarion: StringToTimestamp(Stage var3,"%y...

you need to add more logic when it is PM. Like create a stage variable to check for PM and hour part.

Like

Stage vari: When string = 'PM' and hour part = '12' Then '12' Else If string = 'PM' Then '12+hour part[]' Else hour part

When you bring the field try to change into "yyyy-mm-dd hh:nn:ss" format and use the function. I did a test job and it seems like the function is working only with the above format.