DSXchange

Error : 1 main_program: The section leader on grmtest01db2bta died Error : 2 main_program: **** Parallel startup failed **** This is usually due to a configuration error, such as not having the Orchestrate install directory properly mounted on all nodes, rsh permissions not correctly set (via /etc/h...

can you please elaborate sir ? On what exactly the meaning/implementation of Define a second field consisting of VarChar data type and how it is going to help me achieve the requirement. Thank you..

Thank you very much sir.. But i need to send the records with more than one character to the reject AT THE SOURCE LEVEL IT SELF. Not after any transformations. Hope i am clear.. At the source level itself, while reading ,if the sequential file stage encounter a record with more than one column, imme...

hi friends, Here is a problem i am currently facing in my module. I am reading a file using a sequential file stage. The column in the file is of Char data type. It contains records with single character - for ex : A double characters - for ex : AA more than two : for ex : AABBCCC the requirement is...

The file is a comma delimited file. the sample data looks like "1","GSTBRWS01_SF_LZ_INSRT","ETL","2011-04-15 04:57:32","2011-04-15 04:58:04","2",1072,3768,0,0,"BROWSE_SESSION_ACTIVITY_E","ADWGSTBRWS" ************ Thank y...

sure sir..i will check with your notes and get back to you..

Hi .. Warning messages in the director : 1. node_test01_node1: The open files limit is 2000; raising to 2147483647. 2. EQL_File,0: Field "STRT_TS" delimiter not seen, at offset: 53 I am trying to read a txt file using a sequential file stage. But the records are not getting loaded. There i...

yes..in the unix box it is appearing as it is. even when i try to load it into a DB2 (target) database also no problem. But, when that string with eccentric character/s enter/s the Datastage Environment, it changes.

Hello All, Here is an issue with the eccentric characters [ `e ] . In the Unix box the source file is reflecting the eccentric characters as it is , with out any junk characters. But after trying to read the data using a sequential stage (source) level it self,the VIEW DATA is reflecting some trivia...