DSXchange

hi All, There is a requirement in project is that we need to implement the following in two ways the same code as descriped 1.The job1 will give me a output file with two columns Id and Name 2. I need to use job1 file output to the job 2 as parameter( Id and Name) What job2 will do is that it will h...

Hi Can any one help me how to use the job parameter for the job. Job-1 is giving the output as two feilds Id(param1) and the where_condition clause(param2). job-2 will use the above feilds in as the parameter. Can i know how to call the job parameter of job1. because i want to use in the job2 SQL wh...

Please explain what a "config file" actually means in the context (that of a Sybase stored procedure executed from the command line, presumably). Do you mean a "script file"? Can you provide an examp ... Ray, You have understood correct, can you please guide me in how can we exe...

Hi, Can anyone guide me how to use config file as the input to the job. Requirement- I am using a sybase stage with a stored procedure contains more than 7 left outer joins to the master table and then using sort and aggregator stage (Max() function for row to column conversion) and loading into seq...

Hi, I have an requirement in which i need to check the condition for multiple tables and populate for a single column. Ex- I need to check [if tableA.col1=tableB.col1 then tableB.col else if tableA.Col1=tablec.Col1 then tablec.Col else tableA.col] as newcolumn I could write in the stored procedure o...

Is there any way that we can get the record count of a hashed file? I do realize that we can write it to a sequential file and then get the count. When it comes to datasets, we are able to use the orchadmin commands to get the count. Similarly, is there any way to get the record count of a hashed f...

Here are the steps you could proceed with
1. In job properties, in after job subroutine tab select EXEC DOS

2. Can use the below command
(copy /b /y File1Name+File2Name+File3Name FinalOutputFileName)

Hi,

As i have to develope routines and new to data stage. Can Anyone help me providing documents for developing routine with simple examples how to start with it.


Please advice..

Hi all, I have an problem with FMT function. I have requirement where i have to do RIGHT ALIGN Space fill for decimal field. eg:- Quantity- decimal(17,4) is the input given OutPut:- < 645.0000> So to do right align space fill i wrote the below derivation for quantity filed as FMT(Quantity, "17'...

Hi All, Is it a good idea to have around 3 sort stage and 3 aggregator in a single job... Is performance wise also is it good....? In my case i have used sort and aggregator 1) for Sorting the data as per requirement 2) Sorting and doing row to column by MAX 3)Finding the number of records passed to...

Hi I have problem with the sort stage.My job is getting aborted by the below FATAL ERROR: "CopyOfTestRSNAM_ExtractBPSA_Seg10..Sort_28: ct_fetch failed or canceled Sybase Open Client error: ct_fetch(): user api layer: internal common library error: The bind of result set item 6 resulted in an ov...

My requirement is that for example INPUT is given below empid line_num Text 100 1 a 100 2 b 100 3 c 200 1 aa 200 2 bb 300 1 ccc OUTPUT should be:- emp text 100 abc 200 aabb 300 ccc I have applied the same logic as given above. but i am not the output as above. Instead the output i am getting is emp ...

Thanks, i have applied the same logic what you specified. Are we not going to use any constraints.

Thanks it has been worked out...

is it not necessary to convert decimal to character...I tried working with CONVERT function but i am getng the below warring.
"Insufficient result space for explicit conversion of NUMERIC value '128119000.00' to a CHAR field".