DSXchange

Thanks
This really helped..

Appreciated.. thanks again

Dear All

I'm trying to validate a string, which has arabic and English data in it..

If the data is in Arabic then pass '' else pass the column as is..
Could you'll pls help in this case.

Tried Alnum/Alpha, but doesn't work

Hi Im trying to read a file which was created as a part of a server version, and has to be read now in the parallel version. At times i'm able to read the file, but when I run the job it gives me the below error. For example: Delimiter for field "MANDATE_INSTRUCTION" not found; input: {c7 ...

Hi
Thanks
It was not reading the null values, specified the null value, and the job is working fine now.

Thanks

Hi Im trying to convert string to timestamp and I get the following error APT_CombinedOperatorController(2),2: Conversion error calling conversion routine timestamp_from_string data may have been lost the input column value from the sequential file is for example CRT_DATE 2006-03-15 19:39:12 I need ...

I want to confirm that a conversion here is possible. Some years ago I developed a Basic program to change the header, remove or replace several properties and adjust the category format in a DSX file, no matter if it was a Server or a Parallel export, or contained jobs, routines, shared containers...

veera24 wrote:Have you tried importing without the executables?..i haven't tried this yet..

I did try, it doesn't work..

Hi I have a dsx, which was on Datastage 8.0, on unix Now, I need to import this dsx into 7.5, and when i do so, I get the error. File C:\Baksh\TEMP\import.dsx does not appear to be a valid Datastage export file or is from an incompatible release. A valid DataStage export file is expected to be in Wi...

Thanks Keith and all

Looks like its working for sample data.. it should definately work in the real time...

Thanks again..

Hi I have incoming data as Account Customer ----------- ------------- 1 A 1 B 1 C 1 D 2 E 2 F 5 W 5 V 5 L 5 I 5 P I want the sequence to be generated as Account Customer seq ----------- ------------- ---------- 1 A 1 1 B 2 1 C 3 1 D 4 2 E 1 2 F 2 5 W 1 5 V 2 5 L 3 5 I 4 5 P 5 That means.. for every ...

Well.. it happened to me once, can you try importing all the column definations in all the stages (specially for the source and target stages) again and run the job.

Its strange, but it worked for me once !

Because apart from the Version nothing else changed..

Are you running the job through a sequencer or just the job or the script ? Suggestons Check if anywhere from the above you've defined the job to abort after certain row limit. Check if the admin or someone has set the limit in onsite. Also if its one to one load, try loading it through the sql alon...