DSXchange

Hello, a lookup works fine. But as soon as a condition (the range) is added to the lookup stage, got the error at run time: Lkp_1,0: Operator terminated abnormally: received signal SIGBUS. Condition: Key Expression: Range (DSLink2.lower, ">=", DSLink2.upper, "<=", 0) Key Type: a....

chulett, thanks a lot.

The issue has been resolved.
Our Sys admin folks have created a symbolic link from the default directory, /opt/SUNWspro, to the installation dir., /disk/apps/sunstudio12.1

So no environment variables need to be updated.

You will need to modify your DSParams file settings for the compiler. Go into the Administrator tool, then editing the settings for your project and DSParams. The compiler environment settings are to be found right at the top. Arndw: Thank you so much for your great help. Those environment variable...

Yup, that's what it is. Data is inconsistant and it caused pain!
TD

Thanks for the help! I tried so hard but didn't get the routines to work for me. At last, somebody here helped and I use the "Right" and "field" functions to rearange the data and convert it to the date format later: If Len(DSLink3.DTINTEREST) > 0 Then field(DSLink3.DTINTEREST,'/...

I have columns with date/datetime formated as m/d/yyyy. I want to convert them to yyyy/mm/dd. I see that DS has a routine called DateGenericToTimeStamp. Could anybody tell me how to use this routine in Transformer please?
Thanks in advance
TD

I should have mentioned that the job in fault is one of the jobs which are all in a sequence job. I deleted the table which had extra records and ran only the job which caused trouble individualy. I got the correct number of records then. I checked the job in fault and compared with the others in th...

I ran a job to extract data from Sybase to DB2. The number of records are more than expected. I found one of the extra records in the target table. It looks like real data but it is not from the source table. I should mention that I have done this many times from server to server, database to databa...

The Help says I can do it in the Execution page but the execution mode is greyed out in the FTP stage. I tried to change it by clicking the other options. So far, no luck...
Thanh D

Thank you so much for the reply but do you know where I can enable tracing in the FTP stage?
Thanh D

Thank you so much for the reply but do you know where I can enable tracing in the FTP stage?
Thanh D

Thank you so much for the reply but do you know where I can enable tracing in the FTP stage?
Thanh D

I have run lots of FTP jobs but lately the log has shown this error quite often. Sometimes, the job runs until finished. Sometimes, it hangs and I have to abort it. The log still shows how many records were ftp'ed although the job aborted. FTP_Enterprise_4,1: error in readCommFifo or ftp command fun...

I used DB2/API to do this before. The thing is our datastage server connects to DB2 mainframe and on mainframe site, the administrator sets the timeout for non-activity thread is 30 mins. When I ran the job, it took more than 30 mins to get the input data and processing before the job could start wr...

Hi all, I'm trying to use ODBC stages to connect to DB2 database to read a record in and update it after. When I set ODBC Properties's settings to have a SQL generated, I got the error below: ODBC_Connector_1: [IIS-CONN-ODBC-000104] The connector is operating in autocommit mode. Rather than using pr...