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
Search found 270 matches
- Thu Jun 21, 2018 8:40 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Change capture warnings
- Replies: 1
- Views: 1985
- Sun Dec 03, 2017 11:06 pm
- Forum: General
- Topic: Help with DSExecute in routine
- Replies: 5
- Views: 3607
- Sun Dec 03, 2017 3:23 pm
- Forum: General
- Topic: Help with DSExecute in routine
- Replies: 5
- Views: 3607
Help with DSExecute in routine
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...
- Sun Nov 26, 2017 10:42 pm
- Forum: General
- Topic: using SQL in routine
- Replies: 7
- Views: 4501
- Fri Nov 24, 2017 12:36 pm
- Forum: General
- Topic: using SQL in routine
- Replies: 7
- Views: 4501
- Fri Nov 24, 2017 10:48 am
- Forum: General
- Topic: using SQL in routine
- Replies: 7
- Views: 4501
using SQL in routine
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' '"...
- Mon Nov 13, 2017 9:26 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: involking parallel routine
- Replies: 3
- Views: 3550
- Sun Nov 12, 2017 8:52 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: involking parallel routine
- Replies: 3
- Views: 3550
involking parallel routine
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.
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.
- Wed Oct 18, 2017 8:58 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: where condition in update statement issue
- Replies: 4
- Views: 3540
- Wed Oct 18, 2017 8:14 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: where condition in update statement issue
- Replies: 4
- Views: 3540
- Tue Oct 17, 2017 10:16 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: where condition in update statement issue
- Replies: 4
- Views: 3540
where condition in update statement issue
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...
- Mon Oct 09, 2017 1:35 pm
- Forum: General
- Topic: Job elapsed in DSGetjobinfo
- Replies: 4
- Views: 4108
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...
- Mon Aug 21, 2017 8:01 pm
- Forum: General
- Topic: Job elapsed in DSGetjobinfo
- Replies: 4
- Views: 4108
Job elapsed in DSGetjobinfo
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...
- Sun Aug 13, 2017 11:08 am
- Forum: General
- Topic: server routine
- Replies: 2
- Views: 2701
server routine
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...
- Tue Aug 08, 2017 9:42 pm
- Forum: General
- Topic: DSGetJobInfo
- Replies: 4
- Views: 3539