DSXchange

If I perform a simpel tr on the file the nulls vanish.

Roy,
I changed the reading column type from varchar to char(8).
In a transformer I mapped it to varchar.
Same issue.
Is there some other way I should be converting

Hi roy.I have tried with datatype varchar with no lenght and also with max length. Here are the diff examples ie.e if the input is HEX= "50 2D 00 00 00 00" Then if I put a varchar(max=2) I will get "50 2D" correctly, If I put varchar I get "50 2D 00 00 00 00" If I put v...

Am trying to read a fixed width char field from the database. I can see that the file on the output has trailling 0s so in HEX it would be say 50 2D 00 00 00 00 I want to trim these or atleast replace with spaces. I have tried convert(char(000)," ", ..) also have set the APT_PADCHAR to 0x2...

If you can afford the overead of another job you could use e.g. the Dynamic RDBMS stage to run a sql command/file in a job and call that from the sequence.

Yup, never tried older version on any windows platform. But does EE version of x2 run on XP.
I remember trying 7.5x2 EE on XP and running into some issues, but was told it wasn't supported so didn't try harder. On windows server 2003 it worked out of the box.

I believe older versions ran on Windows 2003 server too.
We have been using it on Windows 2003 for dev purposes.
The code base is different so too are the issues.
That is we have seen issues on unix but not on windows and vice versa.
These were very infrequent. All in all quite stable for dev.

When does this happen
1. consistently for one instance or randomly
2. Does it happen when running one at a time or all concurrently.

Thanks roy, Where should I look for temp sort files. I am cleaning all the files our job is using and creating between running the tests for runing 1 at a time and multiple concurrently. The jobs run cleanly if running one at a time. Should I be looking for temp files which DSEE is creating. If so t...

We are getting the following error when running multiple instances of our job concurrently. We have even tried running only 2 in parallel. Have checked MFILES etc. It seems to be happening either while in a sort stage or a join stage. node_node1: Player 4 terminated unexpectedly. [processmgr/player....

Try this first: 0.Create a copy of job. 1. Use a user which has write privilages to database being read from. 2. Remove all APT_TERA env variables. 3. use unecrypted password. 4. See if the above works. If the above works then try using encrypted password. If both work then go back to orignial job a...

I have multiple > 100 schema files which I would like to import into the table definitions. Is there a way I can import multiple. The only options I found are one by one which will be a pain.

We have the same issue. It compiles a little faster if we compile from a machine closer to the server as opposed to over a vpn or a longer connection. But it is still sloooooooooow in both cases.
anyway am looking at the various environment parameters. Will psot if I find anything.