DSXchange

Thanks a lot for your replies. But is it possible to use Sequential file stage instead of Hashfile stage for lookupups. Please let me know.

I kept the hash file key column data length as Char(2000). But the key column is not accepting more than 768 charecters. Can anyone please let me know how i can overcome this limitation.

Thanks.

Is there a way to receive return values (a recordset or return codes) from Microsoft SQL Server 2000 Stored Procedures in Datastage Client Version 7.5.

Thanks.

Hi,

Is there any way to copy or download the table definition into excel format. Please let me know.

Thanks.

Hi, I am getting the following warning message when the execution of job completes. Program "JOB.432385634.DT.1369540148.TRANS1": Line 514, Attempted READ of record ID larger than file/table maximum record ID size of 768 characters. The job is creating a xml file using XML Output Stage. Jo...

I need to validate a xml file against its schema. Can anyone let me know which stage i can use to do this.

Thanks.

Can any one help me out regarding this.

Thanks.

My XMLOUTPUT Stage is creating xml document as below. <transactionid> 00 </transactionid> <tracknumber> 0 </tracknumber> <key> N/A </key> But the data contains leading and trailing spaces between the tags. Please let me know which option i need to check or uncheck in order to avoid these spaces betw...

Can anyone please let me know the size of longnvarchar SQL Datatype in Datastage 7.5 I am using this datatype in folder stage to retrieve an xml file which will then passed to xml input stage for loading into Oracle. Using this datatype longnvarchar what will be the maximum size of file we can retri...

ray.wurlod wrote:I'm sure this has been covered before. Did you try a Search?

I have searched the previous xml topics, but could not find anything which is specific to the above mentioned requirement. Could you please give some idea regarding how to handle repeating blocks in xml.

Thanks.

I need to generate a xml file using xml output stage. Please find the below xml schema. Each <inventory> block should have unique <statusid>. Each <company> block should have unique <transactiondate>. When <transactiondate> changes xml file should have a new <company> block. When <statusid> changes ...

Please let me know, what are the web enabled features available in DataStage product suite.

TIA.

I need to load data from Sequential file to Oracle 9i database. The average file size will have 30k rows. Please let me know which stage(Oracle OCI or Oracle OCI Load) shall i use to improve the performance.

TIA.

Thanks a lot Craig. I specified the local directory, now it is ftping the files in that directory. I don't know we have to specify the local directory explicitly. When ftp script is running, its execution control is under Unix, But how datastage server changed the location of the ftped files. This r...

Please find the below log file content. It actually opens the port and successfully ftping the files. But the files are not getting copied into the local unix directory. PCJB006..BeforeJob (ExecSH): Executed command: /dsProjects/data/yga_data/nt2unixcp.sh *** Output from command was: *** script begi...