DSXchange

Hi thnx for the responce, i dint get u , can u pls clear me once again. my req is to store all the job details..in one file, and stage details in one file and link details in one file...so i wil have to save allthese files seperately . at last will call them in a job and store in to tables. thanks ...

Hi , can any body give me the code for executing this first line. since.. the whole file reads as a single coloumn..i need to extract ..each field am facing this prob .. thanks much in advance. Is your seq file stage properties are set to read complete report of one job as single row or are you read...

Hi frnds, i need a BASIC code for the below senario. i give a job name in run time. i need job info like start time , end time, status of job , elapsed time. up to here no prob. and in the same code -- i need to extract all the stage name, stage start, end time , status code, row cont, and cpu time....

Hi thanx a lote for the responce, according to my job, am having a seq file as i said it clearly ..that am reading a xml file . this reads as a single coloumn. and the xml input stage will parse in to diff coloumns. so am getting this error in the initial stage ..tht is seq stage .that have only one...

Hi thax a lot for ur reply Kirtikumar, yes ..my seq file reads as a single colomn and as u sugested i have entered teh the substring .. Read1.CONTENT[Index(Read1.CONTENT, 'Job start time=') + 15, 19] but this says not valid exp..(red color) my input coloumn is Read1.CONTENT , can u tell me where the...

Hi Ray, i have linked the single coloumn comming from the seq file to transformer..and linked the same coloumn to all the coloumns which i have in diff other transformations. seq->trans->4 other trans | remaining job. but my job is aborting for several reasons..one is below..can u pls guide me what ...

Hi ray , thanks. what i understand is to read .dtl we have to use seq file giving the file name.ok fine. when we are reading an XML we use XMLinput to pass the total single coloumn to make it ..individual..i mean multiple coloumns.right. like that do we have any shuch ..stage for accessing this .dtl...

Hi frnz, am creating a detail file from the before sub routine execSH the code am giving is (input) #$DSPATH#/dsjob -report #$DSPROJECT# #JOBNAME# DETAIL >#$DSLOGDIR#/#JOBNAME#.detail since this is my first trial , am not aware wether this is correct or not. can anybody help me how to read that file...

Hi Kirti kumar, thanks for the responce. my seq file is reading the whole XML as a single record and in a single column"CONTENT" as u said i placed a transformer in between the seq and XMLinput. and used the ray's code like "<CONTENT>":CONTENT:"</CONTENT>" and inthe XML...

Hi ramesh, thanks for ur reply, i dint see any folder stage in my pallette can u pls tell me where can i get it from .am in px jobs. Have you tried reading the input file from a folder stage, and passing its contents as the XML source column? We have quite a few jobs doing the same and it works fine...

Hi ray , thanks a lot for the responce. my job seems like this: . . . . . . . . . . . . . . . . .|---->transfrmer----database seq--->xmlinput -->|---->transformer---seq1 . . . . . . . .. . . . . . . . . .|---->transformer---seq2 . . . . . . . . . . . . . . . . . .|---->transformer---seq3 so , am rea...

Hi all, am facing the same prob here,am reading the xml file which is created runtime for the job name given in run time.which creates a log file as an xml file. the properties goes like this.. read method:specific file options are all as default..settings. format record delimiter:null field delimit...

Hi Ray,
can u pls describe it clearly..? and am not clear regarding using that tags how can we do that ,and if u have any doc's regarding this can u pls fwd to me.
thnx much in advance.

ray.wurlod wrote:In that case you will need to incorporate adding tags into your own derivation logic. ...

hi , am not that much expert to ans this..but i have some thing to share with u, i can see ur path is "/ascential/datastage//folder/xml/data/*.XML." ok , before folder ans after datastage specify only one one "/" for ex:"/ascential/datastage/folder/xml/data/*.XML" dont ...

Hi, am using putty to acess unix remote server, can u pls desc. clearly the proces up to creating .o file how to compile the c++ or c program in unix, can we also write code in unix and make it .o file.
thanx much in advance.