DSXchange

With quite a bit of digging, looking in the &PH& files, it appears that when a data set is not found it throws this error. The phantom output in director is vague and incomplete. The error in the &PH& file is a little better, "A file or directory in the path name does not exist&...

Kim, yes I'm talking about a dictionary file. I'm curious as to the max length of a job name in DataStage. So I issued LIST.DICT DS_JOB and see that the output format on NAME is 20T. Now, we all know that you can name a job more than 20. In some universe documentation I dug up, v9.6 BASIC guide, I o...

Can someone explain to me the difference of display length vs. character length in universe? When I query a dictionary file and the output display states 20T, what does that mean? I've searched universe docs and most information points to the FMT function. T for text justification, but what's the 20...

We do something similar to what you suggest, but there are restrictions on its use. We currently have a auto-conversion process in place that detects the receipt of a file and kicks off an associated job. It uses a web interface and is written in java using DataStage API. It has an internal control ...

What if you have multiple users and many, many jobs that could be run? Is there a way to setup the server to que up jobs that users kick off so one doesn't have to always submit a job through a controller? We wouldn't want to set up another layer like that with as many jobs as we have and each with ...

When creating the routine you would choose "Before/After Subroutine" from the Type box on the General tab. This will affect your options for arguments. You are only allowed one input argument and you get to return an error code(non-zero would stop the stage or job). If you need two argumen...

Why not set up the routine to run as a before or after routine, then you wouldn't need to use TCL?

Myles

Myles Sigal
Technical Analyst
Thomson - Medstat
777 E. Eisenhower - 435B
Ann Arbor, MI 48108

myles.sigal@medstat.com
734-913-3466

Regarding #4: It's been my experience that you do not have to recompile a job if you change a routine's code. Yes, you have to recompile the routine, but not the job that calls it. This is one feature we enjoy. We can change a routine in one place and not have to change any jobs. Shared container ch...

Can anyone tell me if there is a line continuation charactar when writing DS Routines? I want to split up long lines across multiple lines. Or does the statement have to be all on the same line? Thanks, Myles Example from Visual Basic, one can do the following with the underscore: If this = true And...

Chandra - You can find an old post on this topic by searching. Here's a link to that post: http://www.tools4datastage.com/forum/topic.asp?TOPIC_ID=84050 and a quote from it: The quick solution is to clear the status file for the job (this is in the Director's Job menu, but must have been enabled fro...

We'll often get this error when we have two transformers back to back. The job will abort even on the first record. Taking out the second transform, if possible, usually takes care of it or we'll land the data to a file. These are extremely frustrating and time consuming to diagnose. I'm not much he...

Our users receive this type of error somewhat frequently. A common cause is a mis-typed stage variable in an expression. You can compile successfully with incorrect case but when the job runs you'll receive this kind of error. Example: If myStageVariable = "good" Then "good" Else...

Can you grab and drag the repository window around? Another option is to delete the registry key(s) for Designer. It will return Designer to the default state. Delete the folder and all underneath: HKEY_CURRENT_USERSoftwareAscential SoftwareDSDesign Myles Sigal Technical Analyst The MEDSTAT Group 77...

Really, I searched for something about it in the forum before I posted.[:I]

That's what I figured after checking the help, just wanted to be sure.

Myles

Is it possible to change a job parameter from the job control code? I can successfully execute the DSSetParam function, err = 0, but the parameter value doesn't change. I want to read in the parameter as it was supplied at runtime, then modify it based on what it is.

Thanks,
Myles