DSXchange

Having a Director (or more than one) open in log view doesn't help. Switch to Status view, or minimize Director, or (best) close Director. As far as running jobs hitting the logs is concerned (exactly how did you establish that this is happening?), find out what kind of things are being logged and s...

Please don't mark your posts "urgent" or request replies "ASAP". There's no such thing in a forum such as this, indeed it's offputting for those of us who try to contribute - but still have to earn a living. We are not on line 24x7 merely to answer your questions. Turnaround time is not that bad, a...

Just out of curiosity, WHERE did you do this?
Your original post suggested that you were using a parallel job, which limits the places that you can use BASIC functions such as Iconv() and Oconv(), and the square bracket notation for substringing.

Thanks. :D My job shall clear the table and insert only one row. However i do have an after-job routine which only touches a file. If anything sets the ErrorCode argument of your after-job routine to a value other than zero your job will abort. That is the documented purpose of the ErrorCode argume...

Thanks but this forum is just too time consuming. You guys seem to function just fine without me. We will never catch Ray anyway not that was ever a goal of mine. Ray's and Ken's knowledge covers a broader range of topics than mine ever will. Well, just wait till ADN catches on. Then there'll be ev...

Can the file names be grouped using a wildcard? If so, you can use MGET within FTP (or MPUT, depending on the direction you're travelling). Use PROMPT to toggle confirmation of wildcard matches. You can trigger this from DataStage or not, depending on your preference. If you want to do so, search th...

Just to rub it in, so to speak, DS_JOBOBJECTS is not part of the original DataStage respository design. It was introduced well into the life of the product. One of the reasons UniVerse was originally selected as the DataStage engine was this flexibility. No data types, nothing is enforced, so it's q...

What you have created is a transformation function. Check in the routine properties; its type is in the drop-down list. To invoke a user-written function from DataStage BASIC (whether job control code, before/after subroutine code or even another transform function), you must first declare that func...

Ok first where are the settings for throwing away incomplete rows....dont member that one from training classes Jim In the Sequential File stage go to the link properties (Outputs tab), select the Columns tab, then scroll the grid to the right using the horizontal scroll bar at its base. It's there...

When a DataStage client connects to the server, a dsapi_server process is started (by the dsrpcd daemon) to manage the connection between server and client. If any work has to be done, which is usually the case, the dsapi_server process will spawn a child dsapi_slave process. These processes are unr...

Oconv(date(), "D-YMD[4,2,2]") should work, at least in my mind it should..but it does not. is there a better way to do this so that I have a constant load date, with out a time stamp? Jim Date() returns the system date. Prefer the system variable @DATE, which has its value set at the beginning of t...

Ray, So, if I do this task in separate jobs how would I assign the ID from master table to foreign key of Detail table if I can't see the ID from Master table in the second job? I can not load a detail table without information for foreign key (derivation). Also, can you explain changing demantions...

You can create the hashed file as indicated, or you can use a CREATE TABLE command called via DSExecute. For example: Stmt = "CREATE TABLE MyTable (" Stmt := " key INTEGER NOT NULL DEFAULT NEXT AVAILABLE," Stmt := " col1 VARCHAR, " Stmt := " PRIMARY KEY (ke...

Before/after subroutines have exactly two arguments. Therefore you have not created a Routine whose type is "before/after". Therefore you cannot call it as a before/after subroutine. The two arguments of a before/after subroutine are InputArg, which is the contents of the Input Value field from the ...

Enable server side tracing.
Do one in Manager (Import from XML, export to DSX).
Disable server side tracing.
Examine the trace file.
Mimic the subroutine calls in your BASIC routine.