DSXchange

i'm trying to convert string into date format. for example i get a date value as a string such as "01/03/2005" than converting into date format: 2005-03-01. i'm using this code: Oconv(Iconv("inputColumn", "D/E"), "D-YMD[4,2,2]") but executing it in the transf...

HI akarmarkar, Its not at all a issue if you have two jobs with the same name in different projects in a single datastage server. The message saying that the object already exists could be for some other reason Regards Sreeni I think you did not get..if he is connecting to different project and imp...

Use DSGetJobInfo() also....

Thanks,
Anupam

Capture link data rejecting in update and try to insert into Informix using Informix SQL client tool...It will show exact reason of rejection in database.

Thanks,
Anupam

Are you able to view the job from manager into you project?? Datastage Manager connects to all project you are using on server..May be you have multiple projects and while importing it may be you imported into different project and looking for job into different project. While importing open project...

Hey Kris,

I think you can try to get solution using @INROWNUM
In stage variable use @INROWNUM=1 and Lookup comparsion is successful which will verify your file header column value then process other rows else dont process row by providing condition in constraint.


Thanks,
Anupam

Kris,


Count * group by 1234 where TYPE is ALPHA.
Count * group by 1234 where TYPE is BETA mulitply by 3.

Join both query on 1234 and add both count....

Thanks,
Anupam
akarmarkar@smart-bridge.co.in

I think your order is not correct. 2nd variable should be last if you are using lookup...

Thanks,
Anupam

You can also use hash calculator utility , where you can specify the size of your file and hash caculator dispalys syntax to create hash file.


Thanks,
Anupam
akarmarkar@smart-bridge.co.in

dwandbi wrote:Hi,
Why do you get DSP.Open error even though we are able to connect to database while pulling data from tables?

thanks,
latha

Latha,

Can you explain more where are you getting this error.

Thanks,
Anupam

Thanks Anupam, for the solution. I am looking for the difference in dates , say 12/31/2002 6:00:00 PM and 12/31/2002 6:00:00 PM and 19/31/2002 6:30:00 AM where both r having datatype as timestamp and target is having datatype as NUMBER (here difference will be in MInutes) Can u plz give the Solutio...

If you are using Database stage then you can define INNER,RIGHT,LEFT, IN, NOT IN... manually in user-defined query...OCI consits of IN, NOT IN but RIGHT,LEFT outer join is not there...If you write user defined query you can tune query in your own way...

Thanks,
Anupam

Use following to get time in min
Arg1 and Arg2 is time ex: "02:34 am"

Result=Oconv((Iconv(Arg1[1,8],"MTH") - Iconv(Arg2[1,8],"MTH")),"MTH")

Ans= (substrings(Result,1,2) * 60) + substrings(Result,4,2)


Thanks,
Anupam

User defined SELECT query in stage......

Thanks,
ANupam

Hi,

From database itself you can get days difference by writing user defined query oracle source. Or using ICONV and OCONV with "MTH", You can get time difference in Datastage.


Thanks,
Anupam