DSXchange

Thanks for all your help. It seems to be just an issue that I have. What I have found also works is to place portions of the statement in yet another stage variable and evaluate it there.

Thanks.

I am just wondering if anyone has ever had an issue with the IF statement and the ordering of the clauses within the IF statement. On several occassions, I have tried to debug some of my jobs and the problem ended up being the order of the comparisons I was making in an IF statement. For example If ...

Thanks for all your suggestions. I will try them out and see if I can isolate the problem. I do know that the database tables being locked is not the problem as I am the only one accessing the tables and I have checked with the DBA a couple of times and the process is not being blocked so it has to ...

Hi, I have a datastage job that uses an OLEDB connection to a database, runs a script in the BEFORE SQL and then splits the data into one of three text files located on the network. The transform for this job is simple as it only checks the value of a column to separate the data into the files. I am...

Thank you.

Turning off the option of "Automatically handle...." does the trick. I never would have thought of that. :D

Hi, I am attempting to call a routine using a Routine Activity in a sequence. Based on what the return value is I decide on which path to follow. However, although the routine is being called, it always returns the error DW03100sLoadBackOut3..JobControl (@routCheckinsCertStaffRptAssoc): Routine DSU....

I'm so embarrassed. I double checked and you are so right. I had one job from another category I was using not set to string.

Hi, I've created a set of jobs which require a date and time parameter. In the job, I've created a string parameter "extract_start_dt". In the job, if I set this parameter to "2004-10-01 00:00:01.000", the job will run okay. I've also generated a sequence to run all these jobs ag...

Well, that certainly would make it much simplier
I was just curious about the date.

Thank you Kenneth.

I have a job that reads in a timestamp of 1900-01-01 00:00:00.000 and I want to read it out to a sequential file as 1900-01-01 00:00:00. The problem is DataStage for some reason is not reading the 1900-01-01 properly. The other date statements will convert properly but not this one. The statement we...

I have done this before where the temp table is created and populated in the before SQL then read in the same stage's user defined SQL. I think that this is about the only way you could use the temp table since (from what I can tell) each OLEDB stage in the job has it own OLEDB session. I never tho...

I have tried creating a temp table and then reading the results back in another query all within the same stage, however, I get a "Link initialization failure" every time. Therefore I wasn't sure that temp tables were possible within DataStage but if it is possible I will have to keep tryi...

Hi,

I am wondering if it is possible to use an OLEDB stage (connecting to SQL server) to create temp. tables on the fly and then read in the results of the temp. table to DataStage for further processing.

Thanks.

If it's globally cataloged you need the asterisk in the DEFFUN declaration. For example DEFFUN SecureRoutine(Arg1,Arg2) CALLING "*SecureRoutine" I finally got it to work. Yeah :D Thanks to both of you again. I couldn't have done it without your help and I learned a lot in the process. Tha...

Well, I've tried both suggestions but I get the same error messages after I've tried to create the universe function in another project. I messages I get are: Program "TSTConvertASN.B": Line 4, Unable to open the operating system file "DSU_BP.O/CONVERTASN". [ENOENT] No such file ...