DSXchange

We found a workaround for this issue. Read the EBCDIC file in a SEQ file Stage allowing all Nulls(i.e.Nullable=Yes on all fields) . the non numeric fields are implicitly replaced by a NULL value/s (High Values \xFF in our case) and we eliminate the need for checking if data is numeric - inside the D...

Thanks guys.. Ray- I had a similar suggestion from a collegue telling me to maybe check the last bit of the packed field to compare if that is numeric. A COBOL program to do the unpacking would take a long time (because of the size of the data) and consume resources on the mainframe. I am trying a w...

perfectly right that the function should work on the unpacked data (thats what i have got in my plate so far) but can we do those validations or checking on an unpacked EBCDIC data?

thanks chulett,
they are packed fields i am trying to check if numeric.
can we use the NUM () function on packed field? my data is being read and shown properly when i say 'view data' .
(i have set file properties as EBCDIC and binary and packed=yes.)

Is there any way we can check if a particular EBCDIC field is numeric ? I am reading an ebcdic file in a parallel job and reading the field as char because I need to do the numeric check. I tried the NUM() and ISVALID(int32,)functions but its not returning true even if its numeric value in the field...

(I am continuing this thread as I didnt want to open a new one..hope no one minds) I am able to get perfect high values and low values through a server job using function - char(255) and char(0) but when I try to use the same in parallel jobs, I am unable to achieve the same result. (using sequentia...

ofcourse you should use the DB2 EE stage for extract, update and loading of the records. I have used the DB2 EE stage extensively and its extremely fast. just that you need to set it up properly. Also as someone suggested, use all indexes and do a query tuning exercise before you put your code in pr...

Actually the job runs fine if the directory is changed I believe if you can load from one directory and similar permissions exist for the same user, then u should be able to load from any other directory ! try going to the directory in UNIX prompt with that user and opening the file. also 'type in ...

Try to implement some logic as such At the start of the sequencer, create an empty file. delete this file on successful completion of the sequencer. can use after-jopb subroutine. When starting the sequencer, try to see if file is present. If its present it means the seq is restarted after abort - c...

DB2 has a function 'nextval' - try and use it in a script . call this script in the before job subroutine. passing a parameter to this script as how many times the nextval command should execute could be done ,if you include in a while/for loop.. I presume that ID column is using a DB2 sequence obje...

Try to make a workaround job and insert a sort and remove-duplicates stage before the final o/p.(keys for sort and remove dupes should be same.) In this workaround, remove the DB2 stage and instead get all the records in a dataset. Then you can compare the rows from the job monitor to the original j...

Try the following command in the DS Administrator: SELECT * FROM DS_JOBS WHERE NAME='jobname' Or SELECT JOBNO FROM DS_JOBS WHERE NAME='jobname' you should get the job number from the above query ex: 123. The RT_LOG123 will contain log information for the job. similarly rest of the files with 123 num...

If your target can allow NULLS to be loaded, then it is very much possible to load the NULLS directly.

can you do a 'view data' on the lookup reference source? (it may be a dataset or a table) . does it also have the same '******' in the date field?
if yes then maybe you have to look closely at how you are creating the lookup reference dataset. is the date field nullable in that?

you can also try and test the query outside of datastage by replacing each '?' by the actual values from the input.
if that query returns any rows, then investigate further with datastage, else the data that you are trying to fetch is failing to meet some condition in your user defined SQL.

rgds,
Nik