DSXchange

I have tried using OCONV with MP tag, but it converts it to hex. For e.g. if I give OCONV(1234,"MP"), I get "31323334" in my output file (hex values of 1234). I havent tried ICONV, as the help says it converts data into internal format. I will try it. As for the routines, there i...

Hi Ray,

I am not able to view the rest of your post as it is premium content
Could you please tell me some way in which we can pack a decimal field?

Regds,
Vinod

Hi,

Can we use OCONV with MP tag to write packed decimal data to the output? The help says that the MP tag also unpacks the data for output, so I got confused.

Thanks,
Vinod

Hi, I need to create a fixed length file which has to be loaded into mainframe. It has got a header row followed by detail records. The schemas of the header and detail records are different, and there are packed decimal fields at different locations in the header and detail records respectively. $$...

Hi, I have the following expression in a server job transformer: If Not( IsNull (ProcessDate) ) Then (DataTypeAsciiPic9(DateYearFirstGetYear(ProcessDate) : DateYearFirstGetMonth(ProcessDate))) Else @NULL I can guess that it returns the month in yyyymm format. But can someone please explain what the ...

Trying to connect to Informix DB for first time from that Unix server Unix server has Informix Client version installed (7.30.HC4) ODBC stage connects to say database "A" but does not connect to database "B" from that unix server. Informix verison of DB "A" is 9.30 and ...

Hi folks,
Please let me know if there is any solution to this; this is urgent and is an issue on a production server.

TIA,
Vinod

Trying to connect to Informix DB that lies on different unix server than Datastage server. Able to access database thru dbaccess utility on unix server. Following error is given when I try to connect thru Datastage DSR.MetaGeta(GET.DSNINFO)(SQLConnect('tdb1','eureka')): BCI Error: SQLSTATE=60,CODE=0...

Hi, We have an existing set of jobs which access TeraData tables through ODBC in production. While dong a development setup, we get the following error while accessing the table via ODBC: DSR.MetaGeta(GET.DSNINFO)(SQLConnect('TD_BYT','gsir_etl_d')): BCI Error: SQLSTATE=S1001,CODE=0,[DataStage][SQL C...

Just getting it clear - NOTFOUND signifies that data is not present in the reference link, right? Which means that data in the driver has not been found in the reference file. Am I correct?

Regards,
Vinod

No I do not use VC.

Hi Ray, My script is called using nohup and has a trailing ampersand; thats what the problem is. I call my script using: nohup myscript & This script calls the QS CASS job script and if I kill "myscript" which is running in the background by closing my console, the QS job terminates au...

Hi Roy,
I have already done this and the results of the job are different in both cases, and that's how I have narrowed it down to IsNull(). And no, the default NLS mapping is used in the job and the default NLS mapping is the same on both servers.

Regards,
Vinod

I have a QS CASS job which is called by a script running in the background (i.e, the UNIX script is running in the background and this script calls the QS job script). However when I kill the session with which the UNIX script is called, the QS job is killed even though the script is running in the ...

I have a server job which runs weekly, wherein I extract data from a staging table and DM table. The staging data is loaded from a DSS and data extracted from the staging is that which has changed in the DSS within the last 8 days. A comparison is then done within a transformer on an ID between the ...