DSXchange

I think the best answer at this time is no. Setting operating system permissions is not a workable solution IMHO. It would be possible to use use some kind of source control system outside of DataStage (one that has a check-in, check-out function), but you would still have an unlocked and open job i...

Arun, I would suggest writing a routine which would set the user status based on the input row count. This status would be passed up to the calling job activity which would check it in a trigger. The (before/after) routine would be something like this: $INCLUDE DSINCLUDE JOBCONTROL.H Ans = InputArg ...

You could go from one job activity to another both of which execute the same job. The first would have a trigger link to the second which would execute only if the job failed. Then the second would say reset and run. Acutally you could put all this in a loop and run it any number of times. However, ...

You said your input is a sequential file and that it has a column with a null value. How did you accomplish that? I don't see how a sequential file can have a null value. An empty string perhap, but not a null value. Perhaps you should say: If InRec.CITY_ADR = "" Then " " else In...

This happened to us last week when our tmp directory filled up. So, you might check to see if it or any other file systems are full.

Larry

Acutally you can also do it in Director using the filter. I use this frequently.

Larry

Just in case anybody else ever has this same problem. Quoting from Ascential Support: I have reviewed the log files and found the problem is caused by the Oracle odbc driver version you are using to connect to the PSD repository and loading the metadata. The error message: SQL State : '22003' Error ...

First, I am new to ProfileStage. So bear with me if this seems ignorant. After creating a new PS "database" and importing some metadata during the process, I noticed that only 8 of the 12 tables I selected were actually imported. The other 4 had messages in the Process log like the followi...

OK, now is the time for owning up to being foolish! This problem was due to a few people here not being able to see what they were seeing. NLS_LANG was not being set in the dsenv simiply because the export NLS_LANG statement was missing. Adding the export fixed the problem. We have all scheduled eye...

Mrinal, I have done what you requested, but did not get what you expected. The "?" remained "?", they did not get converted to ".". What that means is what I said before - it is not simply that they are only being displayed as "?", DataStage is actually conver...

Mrinal,

That may be true most of the time, but in my case the superscripts are actually replaced with '?'. I can tell this by doing a query in either SQL*Plus or within Toad. Either of these display superscripts if they exist and "?" if they exist.

Larry

Ray, I understand that DataStage will not be able to display this character properly, but it also does not seem to handle it correctly. That is, after the job runs, the data in the target table does not contain the superscript - it has been replaced by a '?'. This can be seen be doing an SQL query (...

I have an Oracle database with NLS_LANG = American.America.WE8ISO8859P1 and the same value for NLS_LANG in our dsenv file. In this database there is a table with a VARCHAR2(10) column which contains superscripts as in cubic feet (ft3). (The 3 should be raised). The hex value for the 3 here is x'B3'....

In your source job, delete everything except the parameters and "Save As" "ParameterTemplate" or some other name of your choice. Copy ParameterTemplate to TargetJobInitial. Open both your target job and TargetJobInitial. In your target job do a "Select All" and a "...

Cut and paste may make it not a lot of work, but on a decent sized sequence it sure does clutter up the landscape! To me, that is one of main benefits of the way the exception handler works now. It makes the flow simpler and centralizes error handling. What we do in our emails is simply identify the...