DSXchange

I think that you do still have permissions issues on files - perhaps in the UV main directory but most certainly in the project directory/directories. Can you have your admin go to the project(s) and issue both a chmod 755 and a chgrp to your datastage group to see if that changes your error? It is ...

Hello Bala,

Have you checked that you dsenv file is correct and contains the correct PATH and LIBPATH settings? Does only your userid get this error? Is this a new installation or has access to Oracle just stop working?

Roy,

Ray has brought up a good point - you can use VLIST go get the instruction in DSP.OPEN at that 4D4 - although it might help you find the instruction at fault it might not help you solve your problem.

I think you are getting the ways an IF-THEN-ELSE is used in a DataStage job confused with how it look in a program or subroutine. In your code the IF-THEN-ELSE construct won't compile because the compiler is expecting a statement in the THEN as well as the ELSE clauses. In jobs this type of syntax w...

Hmmm... odd. What if you just put in, for test purposes,

"If @OUTROWNUM =1 Then 1 Else DSLink3.PermissionID" and see if that works?

It looks as if you used a bad variable name, is it took the value as a literal instead of as a variable name. Please follow Craig's advice and use the drop-down boxes to insert the correct variable name.

Yes.

If you clear the log file of the master job (the one without an instance name) then all of the intances will also be emptied.

I beg to differ. DataStage doesn't care about dates internally, the problem you are having is when a date conversion is done to DB/2. According to the docs, DB/2 cannot store a date beyond 12/31/9999; but it should store 01/01/0001. What happens if you have that minimum date and write to DB/2? Regar...

Use a stage variable in a transform stage. You can either use a initial value that is changed after the first row or a condition which checks the @INROWNUM/@OUTROWNUM as kcshankar suggested to assign the column value depending upon which row is processed.

Santosh,

you can write the pretty GUI interface in whatever language/tool your organization likes to use. This can then execute the "dsjob" command with appropriate options and parameters to run the jobs.

i have tried this code but error messages is comminhg like can not covert string 00.00.00.000000 into timestamp ... Since the second part of the string is the constant for subseconds, it means that your OCONV(ICONV()) construct didn't work. You should debug the portions yourself. I recommend writin...

Senthil,

the DS_... and RT_... hashed files or tables are not documented by IBM/Ascential. Their contents and use change between versions so IBM/Ascential will never officially document them, since that will remove their flexibility of changing them for ever.

Siva,

what does page 9 of the "Stored Procedure Stage Guide 2.0" say on this subject?

Well, the error message starts with a text containing "GET.DSNINFO", leading me to assume it can't connect via ODBC to the database. Can you import metadata or do a view data from another program to any table in this database? If not, you need to configure your ODBC connectivity correctly. Since you...