DSXchange

I am using a SEQ FILE Stage. I am getting the following error while I am writing the output to the sequential file.

ds_seqclose: error in 'close()' - Input/output error

Any idea why this is happening.

Hi, I have a sequence job being triggered by a AutoSys job. There is a requirement that the AutoSys job requires the DataStage Project name. There is only one project setup on the DS Server. Is there any Environment variable that will pass the project name to the AutoSys job. I searched through the ...

chulett wrote:How did you make the copy?

I guess there are 2 types of copies (of course excluding the import/export the .dsx file ).

1. Do a CREATE COPY.
2. Open the job and do a SAVE AS.

Which option will raise the above mentioned issue?

Hi, I have a job which uses a MQ Stage to read messages from the Queue. Its a new DataStage installation on Linux. While running the job, I am getting the following error. Any idea why this is happening and how to resolve this ? main_program: Fatal Error: Fatal: Shared library (mqs.so) failed to loa...

Hi, I need to convert a Date input column having format YYYY-MM-DD to output as YYYYMMDD. I tried Oconv(Iconv(DSLink3.date1,"D-YMD"),"DYMD") but the output is coming as YYYY MM DD. How can I achieve my original desired results? I searched through the DS Help but couldnt find a so...

Thanks for the suggestion guys. I tried using "Date", but no success. The query I am using is: select FundCode, PerfCode, Portfolio, Date from PERFORMANCE where CurrencyCode = 'AUD' and Date >= '2006-06-06'; Here PERFORMANCE is a DRO(Data Retrieval Object), a sort of wrapper used to access...

Hi, I am trying to extract a row having three columns from an application called HiPort. I am using an ODBC stage. The Three columns are col1 varchar(4),col2 varchar(10), date varchar(10). I have used these same column definitions in my datastage job. When I execute the following sql select col1, co...

Hi all, I am getting the following error while doing an insert into an Oracle table using both ODBC as well as Oracle Enterprise edition stage. APT_CombinedOperatorController,0: [DataDirect][ODBC Oracle Wire Protocol driver]Invalid precision value. Error in parameter 19. 0 I searched through the arc...

Hi, I have a source text file which has 10 recs and I am having a few transformations in the middle and putting the output to a sequential file again having 10 recs. Is there any way I can write only the last record i.e. the 10th record to the file. Thanks, check for @OUTROWNUM and mod function. Bu...

Hi,

I have a source text file which has 10 recs and I am having a few transformations in the middle and putting the output to a sequential file again having 10 recs. Is there any way I can write only the last record i.e. the 10th record to the file.

Thanks,

Hi, I developed a couple of jobs few days back. And now when I changed something in the job and try to compile it I am getting the following message: 'Error Calling Subroutine: DSR_NLS(Action=22);check DataStage is setup correctly in project Project1 (Internal Error (81021)) ' How can this be solved...

I have a XML message coming as input. One of the tag/columns has the structure /Message/HiGACTXNULD/JobMetaData/METLJobId/text(). Almost all the tags have this structure. And I am using this in the 'Description' to map it to the respective columns using a XMLIn stage. Now the requirement is, I have ...

Hi, I am trying to access an external application called HiPotfolio through ODBC. There is a frequently occuring problem. That is, sometimes the connection is proper and I am able to communicate through ODBC. But after one or two interactions, if I try connecting again then its not able to connect ...

Hi, I am trying to access an external application called HiPotfolio through ODBC. There is a frequently occuring problem. That is, sometimes the connection is proper and I am able to communicate through ODBC. But after one or two interactions, if I try connecting again then its not able to connect a...

Hi,

I need to store a large data file in a BLOB column of an Oracle table using DataStage. Can somebody plz giv some leads on how to do it? Or some ref material will be equally good. I searched in the DataStage Online manual, but couldn't find any info regarding this.

Regards,