DSXchange

Hi Sudarshan, Thanks for the help, But , I don't know whether I can use the one you mentioned in the buildop or do I need to write the c++ coding for this conversion. If so, can you please throw some suggestions on how to proceed with this. Hi, since you r converting date to timestamp I will assume ...

Hi All,
Can any one of you let me know how to convert the datetime to timestamp in parallel extender jobs.

Thanks in Advance

Thank you very much.That is working.... Try this: // First, load input date string into a date variable APT_Date tmpDate1; tmpDate1.set(in.dtfromfile, "%mm/%dd/%yyyy"); // Then, create new temp variable using Y and M pieces of first date, // and 1 for day. The class APT_Date has a construc...

Hi All,
Can anyone give me an idea of how to compile the buildops.

Thanks..

babu suresh

Dataset Stage : Cryptic broken, understandable to Datastage alone

Sequential Stage : ASCII code , understandable to human eye.

Thank you very much. I will check that.

ArndW wrote:Hello Accord,

this operation is not difficult in either Px or Server and you do not need to do any c++ or other coding to effect it.

In a transform just specify In.InDate[1,3]:'00':In.InDate[6,5] in both flavors to get the required format.

Thanks for the info. I will look into that.
But I am not writting a build-op just for that date transformation alone, I have whole bunch of other transformations also. Anyways I will check that sample folder. And if you have any clue abt the C++ code please let me know.

Hi Gurus, I am trying to write a build-op(first time) in C++ for some business transformations. One of the requirements is, I am getting date from a flat file in the format mm/dd/yyyy and the requirement is to load the target with mm/01/yyyy. Can anybody suggest a way to do this in the build-op. If ...

Craig,

I am going with the Folder Stage. It seems to work. 'Coz my boss says I have spent too much time on that. Thanks for ur help.

Sandeep

Craig, I have given the same command in the cmd window. It works fine. I am not sure why it is not working in DS. I gave the complete file name in the file name option window and the wildcard filter type <dir>*.txt. I tried giving jus the filter option too. No use. I guess, I am making some sense he...

Craig,

Am sorry again... .

I tried doing that now I am getting this error.

ds_seqopen() - Win32 error in CreateProcess() - The system cannot find the file specified.

Please advise

Thanks
Sandeep

Ray, Tried that, it throws an error "no file name to open". Do I have to give anything in the file name option. And for your info my test job looks like this seq_file_stg -----------> transformer ----------------> seq_file_stg (straight moves) Please advise. Thanks Sandeep

Ray/Craig, I am trying to use the filter command option now ,that Ray quoted. I have a question, this might sound silly. But I hope you can help me with this. Say for, I am trying to search for the files with the extension 'txt', in this folder E:\dev\srcdata. I guess I dont have to give anything in...

Sorry Craig, I got ur name wrong.

Ray/Chulett

Thanks for your help. I will try all the three options and see which suits my reqs. I will get back to you guys if I find any probs.
Thanks once again