DSXchange

Pretty sure that database has datatype as varchar2(20) and also while reading from seq file I am reading as varchar. Only thing is not specified any length while reading from file

small correction

it is adding extra spaces in loaded string. If my column has length as varchar(20) then loaded string would be "sachin " + 13 spaces

In earlier post this was not reflecting properly hence confusion

Hi Ray,
but it shud preserve only existing spaces right. And should not pad string with additional spaces based on length of the string.

Hi, We are trying to load flat file on unix server to oracle table through oracle enterprise stage. I have a input column customer_name which contains some trailing spaces which we need to preserve while loading. e.g "sachin " should be loaded as it is and not as "sachin". For th...

Hi, in our project we have lot of resuable multiple instances job. This creates hundreds on instances in single day. We want to clean these instances on weekly basis through an automated process. There should not be any manual intervention. Any pointers e.g we have a batch id generation job which ru...

I have a datastage sequence which runs for 24 hours. I want stop this job on friday night and restart again on monday morning. Restarting can be done manually. Any pointers how to stop at specific time? This should be graceful exit and job should be in stopped/restartable state and not in aborted.

Hi, We have few polling routines in our project which continuously polls particular table at an interval of 60 sec for some entry. Once entry is available it runs the specific job. This routines are placed in individual sequencer and it runs 24/7 once triggered from autosys. We want to run it only f...

We are using 7.5.1 PX. We migrated our datastage code to QA by importing it from DEV. When we are using multiple job compile utility to compile all the jobs couple of datastage sequences show compilation error. e.g S051GPSVendorFeedRequest - Failed << Activity NCA_EmptyChk: Trigger Expression Lnk_To...

We have email mechanism which send emails on completion or failure. We are not getting any such emails.
Plus this job is running since more than 24 hours now.

Hi, We have one datastage job which is running fine in one environment. When we migrated the same job to QA environment it is running endlessly. What could be various reasons for such behaviour. Job design involves a copy stage from which no records are flowing in subsequent stages. Also there is a ...

Hi, I have one parallel job in which is common for two processes. Depending upon process name there are two flows inside it say A and B. Now if process name is A it generates XML file and if process name is B then it generates seq file. Requirement is if job runs for process A then only XML file sho...