DSXchange

in derivation just put column name as it is and see what do you get without checking group by check box.

just to give u an example SQL> select * from tbb1; COL1 COL2 DT1 ---------- ---------- --------- 1 1 17-JAN-08 1 1 18-JAN-08 1 1 19-JAN-08 1 2 19-JAN-08 2 2 19-JAN-08 1 1 21-JAN-08 ---------------------------------------above is input -------------------------- you want an output like SQL> select co...

do you want all the columns to be propageted.

Hello as mentioned by kcbland that first day is always 1 then below code can help you.


'01':'-':OCONV(month.first(month.tag(date()))-1,'D-MY[2,4]')

if it is left blank, it uses current projcet or account for its storage.

as said by Andrw you need to take help of some third party tool.

Pivot is an active stage that maps sets of columns in an input table to a single
column in an output table.

hope you have a pdf named "pivot.pdf" deployed with your Datastage software, that can help you know more.

hello friend,

my question is how are you going to segregate records in file, when you read all files in directory in one go.

becuase for folder stage we have only filename(key) and Records columns to work with.

your two input columns will be colname and colvalueinp.

Hello, In hurry i tried working for your doubt. job design like Input file ----->Transformer------>(2 output) you will require two stage variables. one colvalue and other valuecolumns.(stage variables). your two input columns will be colname and colvalue. define for colvalue -->colvalue :',': DSLink...

hello please let us know where have your parameters like prev_Year, Month, Week, count, been stored, in sequential file or database.

hello, imagine your file named CRT_Requests_15112007.csv is in directory 'd:\datastage\data\india1\sachin' below code check's if file is present and does further processing. fichier2 = d:\datastage\data\india1\sachin\CRT_Requests_15112007.csv OpenSeq fichier2 to fic2 then CloseSeq fic2 Call DSLogWar...

i agree with WoMaWil , where the code is to be put in constraint of transformer stage to populate values in target seq file according to your parameterized month value.

you can write a after job subroutine, which will track your job for successful execution and send a job status in mail. you can use Status_value = DSGetJobInfo (DSJ.ME, DSJ.JOBINTERIMSTATUS) * Status_value Returns the status of a job after it has run all stages and controlled jobs. IF Status_value =...

hello dear taking your request into consideration,

following could help you,

suppose your string is str1=;1234567890' so your output will be like str1[3,10]:str1[1,1]

and the output is like 345678901

this is one of the method i think is efficient.