DSXchange

Hi, I am writing a routine which should read lines in a sequential file and compare the line number with the input argument which is also a number(passed as a argument).If the both the line no and the input value(passed as a argument) matched it should retrive the record to the Ans. I am very new to...

Hi, I have a requirement in which i have a routine which reads the sequential file and this routine is to be called in "User variable activity stage". After this there is a "Job Activity" which takes the record from the "User variable activity stage" by the routine in i...

Hi Kumar_s, My requirement is i will be getting a seq file in which, there will be multiple lines which are comma delimited.Each line is a set of parameters to the job activity. So, i have to read each line and divide them based on the delimiter (,) and pass these list to the job activity which has ...

Hi balajisr, Thats fine..My problem is, can a routine return more than one value. :idea: Eg: I am getting a string, Hi,How,Do,You,Do So in the string i have to extract the strings dilimited with commas.i.e, Hi How Do You Do I have to pass these values to my next Jobactivity as parameter.. :arrow:

Hi,

I am new in writing routines .I am wondering if,a routine can return more than one value or not.
In my requirement, i am getting a string delimited by commas.I have to extract each string delimited by comma.I am using string[] function for attain this.
Or is there any other way to do this.

Hi, I have a requirement where, i have a source column from which i am getting two types of records which are numeric and alphanumeric which is defined as Varchar field in the DS job. Now my requirement is, if a record with all numeric characters comes, the preceding zeros should be deleted. if a re...

Hi Craig,

You are right
But my problem is in continuation to the original post, posted by me...!!

Any Suggestions on the problem..

vijay,

I am just wondering, if you gave me the answer or giving your problem!!

Any suggestions

Hi Craig, I got it!! But i am facing data formatting issues.. I mean to say..suppose if my source value is 00109210s , i am getting 109210s, which is removing '00' from the front(which is the property of a csv file). Similary it will do with the date data also, for instance.. source target 05/11/200...

Hi chulett and Aparna, Thanks for your earliest replies.We are using the delimiter as a parameter in which we are using ',' as a default value.So, i am not keeping the record delimiter as 'comma'.So, i think it should work... You mean to say that even if we don't give the .csv extension it will resu...

Hi, While outputting the ds extract, if we give the output file name with the extension .csv , will datastage automatically convert into csv files.I searched across the forum but there was no post helpful to me. And if it doesn't work what kind of setting to be done in the target sequential file.I m...

Hi Its working now..The data format which is outputting is different form the output which is shown in the pdf manuals.. And the () is because of the RCP..I enabled it in the source but not in the make subrecord stage...when i enabled it across all the 3 stages its working and showing up the require...

Hi ArndW, Acutally i need the source data as shown in the manuals for the 'make subrecord stage'. for which i have used the make vector stage to create three vector columns. This data i am passing through the make surecord stage to get the reqiured output. In my first job (make vector stage) my sour...

hi,


Even i a facing the same problem...Could you resolve this problem

Hi, I am working on make subrecord stage by taking the vector records from a dataset. But i am not getting the required output. I did the same thing which in given in the manuals.But it doesn't show up.. I have three vector columns from my source.But in the output is showing in a strange way with so...