DSXchange

We have two DataStage projects on AIX box. Both projects are sharing the same DataStage server engine. When we try to create a new job, we run in to the following error. We are able to run jobs successfully. The error messages are as follows: Error calling subroutine: DSR_JOB (Action=2); check DataS...

I saved this job with a new name and compiled the new job. I was able to compile it without any problem.

No. There is nothing in red.

Thanks

I am trying to compile a job and I get this error. I am not able to make anything out of this error message. Any ideas? Compiling: Source = 'RT_BP12/JOB.1493257848.DT.1348733279.TRANS1', Object = 'RT_BP12.O/JOB.1493257848.DT.1348733279.TRANS1' ********************************************************...

Thanks for the info. I figured out the problem. I had a typo in Stage name.

Thanks,

Hi, Can anyone tell what are the possible values for DSJ.STAGELASTERR? I tested in a sample job and it returns a value of -7. The doc says its a string representing the last error on the stage. I am confused. I am trying to determine if there is any error on a stage and if so, reject rows for the ne...

It works now. The problem was with dsenv configuration. Here is the exact list of variables required in dsenv file: DB2DIR=/usr/opt/db2_08_01; export DB2DIR DB2INSTANCE=db2epm1; export DB2INSTANCE INSTHOME=/db2/home/db2epm1; export INSTHOME #export DB2PATH=/usr/opt/db2_08_01 LIBPATH=$DB2DIR/lib:$INS...

I think I found a solution. Put this in a function

Ans = @NULL
If IsNull(Arg1) Then RETURN(Ans)
TheYear = Arg1[1,Len(Arg1)-3] + 1900
TheDay = Arg1[3] ;
DSJulianDate = TheYear : "" : TheDay
Ans = Oconv(Iconv(DSJulianDate, "DYJ"), "D-YMD[4,2,2]")

RETURN(Ans)

We added the variables to dsenv and still get the error. Here are the entries in our dsenv file export DB2DIR=/usr/opt/db2_08_01 export DB2INSTANCE=db2epm1 export INSTHOME=/db2/home/db2epm1 export DB2PATH=/usr/opt/db2_08_01 LD_LIBRARY_PATH=$DB2DIR/lib:$INSTHOME/sqllib/lib:$LD_LIBRARY_PATH PATH=$INST...

Yes I did. This is what I tried:

Oconv(Iconv(1900 + Int(104071 / 1000) : "/" : Mod(104071, 1000), "DYJ"), "D-YMD[4,2,2]")

Thanks,
-Anil

I looked at that post. And I tried the following syntax: Oconv(Iconv(1900 + Int(JulianDate / 1000) : "/" : Mod(JulianDate, 1000), "DYJ"), "D-YMD[4,2,2]") I still get the same error. What I noticed was IConv function is not returning any value. Anyone has a working solut...

I am trying to convert a julian date to DB2 date format using the following syntax: Oconv(Iconv(MyDate, "DYJ"), "D-YMD[4,2,2]") I am getting following error when I do that Value treated as NULL Attempt to convert String value "" to Date type unsuccessful The Julian date...

Additional info: I am getting this following error when I try to 'View data' from the DSDB2 stage. ds_loadlibrary: error in dlopen Any ideas why we get this? Am I missing any libraries in the LIBRARY_PATH variable? The database is Db2UDB 8.1.004 and DataStage server 7.1 is on AIX box. Thanks, -Anil

I am getting this error while trying to import any plugin metadata definitions: Unable to initialize plug-in: The data stage server is on AIX box and the plugin is DB2. I only have this plugin installed. The following variables are set in the user profile of DataStage administrator. DB2DIR DB2INSTAN...

Hello,

I am trying to construct a date from string like

IConv("2004-1-1","yyyymmdd")

This does not seem to work. I am trying to insert this in to a DB2 database table and column is of type 'Date'.

Any help is appreciated.

thanks,
-Anil