DSXchange

Kumar, Clearing a log file will not affect the runtime processes and the "CLEAR.FILE" command is the DataStage equivalent of a "truncate table" and, if used on the wrong file, will irretrievably corrupt your project. What has happened is that you still have one or more DataStage background processes...

bapajju,

if are doing two different date comparisons on your SALES_RCRD_TSP column and are AND'ing them together. If I were to rephrase the query it would be like saying "WHERE x=1 AND x=2"

Your query, USER_ID=:1 AND SALES_RCRD_TSP = TO_DATE (:11,'YYYY-MM-DD HH24:MI:SS') AND SALES_RCRD_TSP = TO_DATE (:12,'YYYY-MM-DD HH24:MI:SS') , even if correct, will never return any values. What happens when you do a "view data" in your job? Does it function correctly from within the Designer? This ...

Yes, it is possible. The procedure to do so is documented in the installation manual and a search of this site will also show some threads on the subject.

I can't seem to find any way of finding out whether a job is RTI enabled or not, either. It shouldn't be much work for IBM/Ascential to add this enhancement, but we all know at which end of the queue these types of requests get placed.

There is no need to install NLS in most installations, and I don't think that your site needs it. SEQ({char}) will work - this is to let you find your data, so you use it for a fixed position in a job that isn't working correctly. Also, you could write a routine that will give you a decoded return s...

Craig, we are implementing some comprehensive logging of production jobs at this site. At the same time we are rewriting a number of jobs that will be put into production in the course of the next couple of months, this site uses version control so the job numbers for the new jobs will be different ...

Kris, there is more than one answer to your question in DataStage. The function (if any) to use depends upon the target database or file format that you want. Assuming you have a string coming in, you can use the ICONV() function to parse the date and time portions into their internal formats for ei...

I am looking for a valid way of getting a job's version number using either some DSGet...() function call or other documented method; I've looked at the documentation and cannot for the life of me find a call to get this data. I am aware of how I can go directly into the DataStage repository hashed ...

You do need Visual Studio and the only other requirment, the MKS toolkit, is installed with the product.

With RCP in DataStage Parallel Extender you can get away with not specifying column names in the DB/2 stage. But if you wish to do any manipulation of any columns you will have to explicitly use the column name - and by doing so you will be entering table information into the job. But if you wanted ...

If you only wish to remove numeric digits from the string, you can do a . This will strip out the digits 0-9 in your string.

I hate to be flippant, but you have an error in assignment. It's like asking "why won't my car start" without giving additional information. The error is in a transform stage, and the program is trying to make a derivation (i.e. assign a value) and it cannot. The error message will probably contain ...

Bala, the date functions in PX are very particular when it comes to formatting; and the default of %dd/%mm/%yyyy %hh:%nn:%ss doesn't match your string - thus the output is undefined. You will need to change your input string to have a fixed length format before you can use the StringToDate() function.

Amit, I think you can best avoid this by converting you data type to integer instead of leaving it in a decimal(0) datatype. What is your COBOL picture for this field? It is most likely a PIC S9(x) integer type - so an integer datatype from DataStage wouldn't be incorrect.