DSXchange

hi all,

is there any scope to call a shell script in middle of the job run.
means it is not in before,after job sub routines.

tx

hi all,

cau any one helpme on this?

tx

hi all, i am getting some issue in output format in xml file. i am trying to generate an xml output file from .csv file. 1. If Type and Description are distinct then the output xml is as follows: <root> <ApplicationPrincipals> <Name>JNewton</Name> <Description></Description> <Type>1</Type> </Applica...

Hi all,

can any one direct me about changing the date format..

my input is like:

Thu Jan 19 16:59:51 EST 2006

but i need to output as like:

YYYY-MM-DD T 00:00:00 (format)

it will be done by using iconv or oconv functions.but i am not getting reqd.output
can any one help me with exact syntax

hey Thanks alot Chullet, it is working fine...i need to display "(double quotes)in the field value.. as you said i append single quotes before and after the values... now i got the required out put value... output is an .csv file but when i open in wordpad i found 3 double quotes synbols instea...

Thanks! Chullet, Tried "if then else" with @OUTROWNM in derivation of Transformer,it is working fine. i need default value for a ouput coloumn like "Employee= " : link.coloumnname: " , Dept=S_CODE" Note: link.coloumnname is the value of one input coloumn so i need displ...

hi kcs/ArndW thanks for your replies,can you please help me out detail syntax. Example: for "empno" coloumn, i need to display the value for first row is "x" and for remaining rows (>1st row),i need to display the value is "y" can you please give me exact syntax to defi...

hi all,

what is the better way to join 2files or 1file&1databasetable or 2database tables.

how can we achieve join perform in serverjobs.i am using 7.5.1A

hi all, can any one please help me how to set the values of columns for different rows. i.e. i need to set a output column value for first row is(default to "x") and from second row onwards(>first row) the value of the same coloumn should be (default to "y") how can i perform thi...

Thanks ,I will try this way and let you know further

ThanksCraig for your quick response, We only have sequential CSV source files, we need to format the same into XML target files. We don't have any XML files ready to import via metadata importer. But I understand that to generate XSD files we would require XML files. We do not have any XML files so ...

hi all, i am stucked with one of requirement ,can any one please helpme on this... I want to convert .csv(input) file to .xml file(output) input.csv file format userid lastname firstname email jack wilson james JWILSON@XXX.COM job design : seqfile------------->transformer------------.>xml out In Tra...

hi all,
how do we apply ranking logic using datastage.
as similar as "RankTransformation" in Informatica.
can any one help me on this

tx in advance

hi all,

can any one please direct me to find "how to call stored procedures in datastage"

tx in advance

hi all, as i am very new to datastage development environment,i am prettymuch confused to know about "howmany processors or nodes defined in my project" i connect the client systems through remote connections and develop the datastage parrellel jobs. can any one please helpme to find out h...