DSXchange

Hi,
Is there any limit to the file size that I can read using sequential file stage using read method as Specific file OR is there any limit to the number of files/file size when I user read method as File Pattern?

Regards
Om

Hi all, 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 Hi Scorpion, Good news: Like Rasi said, if the source is a string(char or varcha...

hi, Can you give us your exact requirement? Do you want your transformed data to be in string or Timestamp format? If your input string is of the format you mentioned then you can use Stage variable and get convert "Jan" to 01(in string) and atlast concatenate all into the string you want ...

ameyvaidya wrote:Hi Om,

Wrap Kumar's Function call in ereplace like:

Code: Select all

EREPLACE(Oconv(Date()-1,"DMDY[2,2,4]"),' ','')

to replace all spaces to Empty Strings.

Done...
Thanks a Lot !

kumar_s wrote:Oops a late reply

Hi Kumar,
Your solution looked intresting, but geting the following date format but I dont want the space in between.

"03 05 2006" I want>> "03052006"

Regards
Om

Hi All,

We can run jobs from CLP by using dsjob in the client and server environment both, can we do the same for compiling jobs like we do from client using "dscc" ??
I mean can we use dscc from server(we are using AIX) too.

Any help is appreciated.

Regards
OM

If you're passing a parameter to the job you have to pass it from somewhere - perhaps a job sequence, perhaps a shell script. It's there that you generate yesterday's date. In a job sequence a suitable expression is Oconv(@DATE - 1, "D-YMD[4,2,2]") (Adjust the specification to suit requir...

Hi, I have a situation where I have to extract data from a oracle table which are generated daily with name as "table_mmddyyyy" so if I can pass yesterday's date as parameter in the extarction job then I can select the table which is created yesterday. How can I pass that automatically at ...

Thanks for the reply Kumar, I'm using the following expn: /path/*.csv Regds Om Prakash Hi Om, Welcome Aboard :D Can you provide us the expression you used in File Pattern. I guess you might have given only the path name. Hence the just the name of the files available under the path will be fed as in...

Hi All, I'm new to datastage, I'm trying to read squential files using sequential file stage. I am using read method as "File Pattern" and also try to get the file name from where the data is being picked, but every time I do this I get only one file name though the data is being read from...