DSXchange

Hi Job needs to run only if file is present on server. using execute command stage written command as wc -l filepath/filename and then conditions for output link are custom return output = 0 then no file link otherwise is in file output link. but this logic is not working any suggestion with any oth...

while trying to insert 1.8 million records, in Db2 table using DB2API stage, getting below error INCIDNT_INTAKE_INS,0: Warning: CGI_GCIF_DHCC_INCIDNT_INTAKE_INS.INCIDNT_INTAKE_INS: [IBM][CLI Driver][DB2] SQL0969N There is no message text corresponding to SQL error "-246" in the message fil...

Hi need to replace consecutive space by one single space.
is there any way to do this in transformer in 7.5

[Note - Code Tags added to preserve whitespace - Andy]

Hi, I have on sequence (run restart) with 14 jobs. This sequence run fine till 12 jobs and failed on job 13th in test env. Now for job 13th we have develop on fix in develpment env. fix was to change transaction size on odbc stage which is inserting data into database from 0 to 2000. Question is whe...

I have couple of char columns in source which are concatenated in source stage. So in next stage I have a transformer where the result data type is changed from char to varchar. Next there is one more transformer, where this varchar result column has inbetween spaces, how to remove these inbetween s...

APT_CombinedOperatorController,0: <>: Error message (253898) exceeds the maximum message size (131056); dropping.

Getting above error, is there any way to increase the field length of where clause in filter stage

Hi we are getting error as "could not map table file "/opt/DSResource_3/lookuptable(size 3904542088 byte)":cannot allocate memory.

please guide.

Hi we need delete few rows from hash file on linux.

please let us know the way.

mobashshar wrote:Have you checked the Unicode in your source/target link?

no , unicode is not checked

job is

db2--> pivot-->rmdup-->xmer--> dataset

Transformer_4: When checking operator: When binding input interface field "CUST1" to field "CUST1": Implicit conversion from source type "string" to result type "string[40]": Possible truncation of variable length string. I have char 40 in source and target. s...

Yes Ray, Its exactly looks like that. one reference, one copy, two reference links and lookup.

Now in look up when I give

input as
key1 key2
A A
B A
C A
D H
E G
F A


I get different output rows.

I am doing hash partition on stream key column key2 sort

harryhome wrote:using copy stage in reference only . but still getting the same problem , every run with different output count.

To add, I have hash partition, perform unique sort on input and two reference links

using copy stage in reference only . but still getting the same problem , every run with different output count.

example
input
key1 key2
A Q
B B
C B
D A

Lookup
A 1
B 2
C 3
D 4
Q 5

Expected output
1 5
2 2
3 2
4 1

I have 5 partitions and trying to get distinct records on a key column using remove duplicate stage. getting different number of record count each time I run job.