DSXchange

Hi,

I get this warning for change capture stage with hash partition.
Unbalanced input from partition 1: 10000 records ...

Does anyone know how to resolve this issue?

Thank you

Here's the code.Files.txt contains complete file path. FILEPATH/FILENAME $INCLUDE DSINCLUDE JOBCONTROL.H Call DSExecute( "UNIX",Command, Out, SystemReturnCode) Call DSLogInfo(Out,DSJobName) Command = "wc -l " : Out Call DSLogInfo(Command,DSJobName) Call DSExecute( "UNIX"...

HI, Need your help in resolving the below error from the routine: where File is the value extracted inside the routine for file path and file name. I'm using the command as : Command= "wc -l " : File Call DSLogInfo(Command,DSJobName) Call DSExecute( "UNIX",Command, Output, System...

no, not.
if I use the DB2 commandline processor to run the query it returns the rows.

This command works for the numeric constant values like but not for character value.
db2 -x 'select colum1 from schema.table where colum2='1123'

db2 -x 'select colum1 from schema.table where colum2='abc' '

DSLogInfo called from :0

Result= SQL0206N "abc" is not valid in the context where its used
SQLSTATE=42703

Hi, I want to use SQL statement : select colum1 from schema.table where colum2='abc' Cmd = "db2 " : "'connect to pdw_dev user pdw using Db2dba1'" Call DSExecute('UNIX',Cmd,Output,Status) Cmd = "db2 -x " : "'select colum1 from schema.table where colum2='abc' '"...

Can we invoke parallel routine using routine activity?

If that's the case what is the requirement to create a C/C++/ routine as a external before/after routine. Does it work with same object file of the c code with routine type external function.

Hi,

Could any one please let me know how to invoke parallel routine type external before/after routine

what is the requirement for the parallel routine code when configured as above pointing to object file for calling it using routine activity

Any pointer or example is appreciated.

Thank you.

I used NVL to handle this scenario. andit worked. thanks

DB2 ..tried ...UPDATE SCHEMA.TABLE SET COL1 = ORCHESTRATE.COL1, COL2 = ORCHESTRATE.COL_2 WHERE ( KeY_COL1 = ORCHESTRATE.KeY_COL1 AND DATE=ORCHESTRATE.DATE)



UPDATE SCHEMA.TABLE SET COL1 = ORCHESTRATE.COL1, COL2 = ORCHESTRATE.COL_2 WHERE ( KeY_COL1 = ORCHESTRATE.KeY_COL1 AND DATE IS NULL)

Hi I have a scenario where I want to update a table for records with date column is null If I use generated query with date as a key column, job doesn't update anything in the table. I think custom query doesn't accept Date is null and job fails if I use it. Could any of you please let me know how t...

again... I haven't been able to resolve the issue with DSJ_JOBELAPSED. Can anyone let me know whats happening here. DSJ_JOBELAPSED is a pointer to a character. char *jobElapsed; The same routine works fine with DSJ_JOBNAME which is also a pointer to a char. char *jobName partial code: after defining...

Hi Friends, I need your help in understanding Of jobelapsed return info type from the DSGetjobinfo. It's a char pointer to JobElapsed. DSGetjobInfo says it returns elapsed time of the job in secs. Does anyone know how exactly it returns the result? Is it in the time formal like 00:00:04 for 4 secs o...

Hi all, I want to create a routine to connect to DB using. I get the following error when creating a routine, but it works when creating as a JCL. Compiling: Source = 'DSU_BP/DSU.TableCount', Object = 'DSU_BP.O/DSU.TableCount' *************************************************?* 0012 Command="db...

i figured it out.


Thanks,