DSXchange

thanks UCDI.

Hi,

what should be the value of DSJOBINFO * ReturnInfo in DSGetJobInfo()?
is the right way to call in C in the transformer function to get a status of the another job.

DSGetJobInfo( JobHandle,DSJ_JOBSTATUS, ReturnInfo)?


This always returns 0. Any pointer is appreciated.

Thanks,

continuing on the same post.. this worked for simple Cpp function with no call to DS functions. When I'm calling DS function #include<stdio.h> #include "/opt/.../dsapi.h" char* projects() { char* prlist; prlist=DSGetProjectList(); return prlist; } and after configuring the parallel routine...

Hi, I'm converting Varchar to decimal.. there are leading zeros in the value example- input -003333334 output -33333.34 actual output -0033333.34 expected output-33333.34 I use StringToDecimal to covert to decimal and then divide by 100 to get the required precision. After conversion to decimal(9,2)...

Hi all, I want to parse the data based on the record number 01,02...Its a fixd width file. There are 2 segments for each record. Only the first record has the member ID next to the Record number. I want the output in such a way that both records 01,02 should have the member ID to identify additional...

Hi all, I have a scenario where we receive a file having 6 segments. In the file layout given to us,first 3 colums of 6 segments have same field names like code, record type, seq no. Suppose, Using transformer we split each record types and dump data into 6 tables. First record has a member id .No o...

Hi,
QLExecute reported: SQLSTATE = 42S22: Native Error Code = -206: Msg = [IBM][CLI Driver][DB2/AIX64] SQL0206N "Y" is not valid in the context where it is used. SQLSTATE=42703 (

This is not happening.. Passing Invocation Id as NAME it's taking job name.Bill and not Jobname.NAME.Thats where I got confused.

hi,

Could anyone please help me to understand how does the invocation ID takes the parameter passed from the sequence.

I have a NAME as the parameter name defaulted with parameter value jobname.



Thanks

Hi, I have a scenario where I need to remove duplicates using a complete record based on Y or N indicator. A few columns in the record have nulls. How do I need to partition? This is what I have done, sorted the input rows using sort stage with Indicator in desc. Partitioned the data using all colum...

Hi Chullet,

I have the count. I want to select only a specific number of records from the file.



Thank you,

Hi, I have scenario to select records from a flat file using rownumber. In the transformer if I use the constraint to select rec>10 I get more than 10 . How can I get the exact number of records from a file with exact row numbers attached to them. Rownumber property is used to attach rowninber to re...

I have a scenario where I need to do the rank over function to get the latest record using max key. expected result: 20 1012 AF NA Key v1 v2 V3 10 1012 AF NA 20 1012 AF NA I used the link sort in remove duplicate stage Key columns: v1 v2 v3 Partition method: Hash Retain first record With this I get ...

Values files are not created when you set parameter values in job properties. Rather, these parameter definitions are stored in one of the repository tables that stores job details (specifically, as a ... Here's the link from IBM: http://www-01.ibm.com/support/docview.wss?uid=swg21610390 Which says...

Hi, After entering the values in the value tab of the Parameter set, I do not see the value file being created in the server's default location ../ Server/Project/ParameterSets. The ParameterSets folder doesn't exist at the location. How exactly do I need to search for the value file created on the ...