DSXchange

Hello , Is there any function by which we can change the job parameters of a job while it is under execution. To elaborate,the output of my job is a single sequential file.The name of this target file is parametrized using job parameters. Now the requirements is to create different target files as a...

For folder stage,we are reading multiple flat files of a particular naming convention. We are putting all the output into a single flat file and we want to print the name of the source file(only once) in output file when the data from a new file begin....ie. the file which is currently being read fr...

Yes you can write in an excel using datastage. Just use an ODBC stage. Create DNS driver for excel in ODBC in Administrative tools. After creating the DNS. When you will open the ODBC stage in DS, you can select that DNS and you can link the excel. Keep in mind the fact that this answer is pretty m...

Yes you can write in an excel using datastage.

Just use an ODBC stage. Create DNS driver for excel in ODBC in Administrative tools.

After creating the DNS. When you will open the ODBC stage in DS, you can select that DNS and you can link the excel.

Hi All, Thanks for the reply..... I've found afreeware that converts HTML to XML.....now i'll need to transform this XML as per my need and again generate a XML... I just wanted to know that...in my server edition i do not have a folder stage...so by using XML input, XML transformer, and XML Output ...

Hi All,

I have one situation...where we have to take some data from a HTML page and transform it to an XML output....how can we do that in server job....

i have DS version as 7.5.1.A..

Thanks in advance

My mistake as usual...

hope this will help : -

first create file with header and detail data....and then use another link collector to include trailer to that newly created file.....

yup its complex....

so
Header + Detail = 1st link collector..
then
Header + Detail + Footer = 2nd link collector

that is USERVARIABLE stage----->Routine Activity Stage---->then for ur final job give file path here for file name use and the stage name use: - <Routine Stage Name>.$ReturnValue every time this value should be fed to the job as a parameter

If you know the exact column from where this data is comming then write a routine to read data from file...use help..

then in a sequence use routine execution stage to extact the data and pass it through a user variable stage...and now use this variable in file names

hey thanks all...

I used Kumar's method...its working

to be more precise Header Data sequential file |if Stgcnt1=1 then (write the header data)1\ | ------>transformer--------->details2----------------2---Link collector | |if Stgcnt2=1 then (write footer data)3--/ footer Data sequential file

no it will coz i did that just include 2 stage variables stgcnt1 and stgcnt2

then increment as stgcnt1+1 for stgcnt1
and
stgcnt2+1 for stgcnt2

and apply constraint..
for header- if stgcnt1=1 then.......
then simply details
and then footer as
if stgcnt2=1....

coz this will be satisfied only once

Yes you can do it in a single job......
just create 3 files with header, details and footer....

and then use Link collector having proper link execution order...

Hi All, I am using a single job in a sequence for abt 5 times i.e same job is running 5 times in a single sequence. The first time it is executed it generates a balance sheet file for dec, next time jan and so on... Now i need that 1st time when it runs in the sequence it should simply overwrite the...

Ya i think i should make a seperate job and include in the sequence......
else thr is no option it seems....