DSXchange

Hi, thanks for reading. Is there a way to get the previous job status for a sequencer or a job. If for example I have a sequencer that will always restart from the beginning, how can I ask the sequencer what it's last completion status was. If it finished with an abort or warning I want to send proc...

Thanks this worked for us.

Hi, thanks for reading. Any help is greatly appreciated. I need help with parsing data in an input field. If I have the following in my varchar 255 input filed part1-part2-part3-part4-part5 I want to put part1 and part2 in one field and all other parts in another field. The dash between part2 and pa...

Thanks for the reply. We'll try this.

Thanks for your response... but we need to know where db2 stages are used as 'reference links' and not where the db2 stage is used anywhere in a job. So we are looking for a specific scenario where the db2 stage is used...in this case used as a reference link. Any help is greatly appreciated. Thanks.

Thanks for reading. How to find all jobs that use database stage as reference link. Looking for a search of somekind. Any help is greatly appreciated.

Hi thanks for reading.

When converting string -77 from string to decimal using StringToDecimal function I lose the '-' sign....so the number becomes a positive. Anyone know of a solution for this? What the best way to conver negative string value to a decimal?

Hi, thanks for reading.

Anyone know how to substring delimited variable length fields.

Want to do this in a transaformer

field1: '-' :field2: '-' :field3 = new field

all 3 fields are variable length. How can I in a down stream job pull just "field1"?


any help is greatly appreciated.

Hi, thanks for reading - Anyone ever get this error or know what it means

Internal Error: (size <= blocksize_):

APT_PMsectionLeader(4, node4), player 2 - Unexpected exit status 1.

Unable to allocate communication resources

Hi, thanks for reading. What's the best way to convert a date from mm/dd/yyyy to yyyy-mm-dd? I tried the forum, but not seeing a specifc option for my situtation. Any help is greatly appreciated.

Thanks to everyone for your response.

This worked for me

find FILEPATH ! -size 0 -print

Hi, thanks for reading. Anyone know how to use this command in a "execute command" stage within a sequencer. Want to get the command to work then replace -print with delete so I can delete all empty files. cd /directory_name|find . ! -size 0 -print tried using 'cd' as the command and '/DSt...

Hi, anyone know where I can find in depth information regarding the DB2 Connector stage. Trying to figure out out the architecture and how it works under the covers.

Thanks for reading. Have a job that reads a CLOB field from a DB2 table containing xml (db2 connector). The next stage uses the clob field as input and parses the data/xml using xpath in DataSatge XML Input stage. We then insert into a DB2 table (DB2 Connector). DBA's tell me all is good on the DB2 ...

Let me answer my own question here. The array count and record count don't have to match but the record count value must be a multiple of array size. Record Count is the commit level. The number of records to process before the connector commits the current transaction. Array Size is the maximum num...