DSXchange

Actually you are right. Sorry, i am still learning
Thats why i said "I am not too sure"

It has a space in between. Who keeps a space in a unix file.
If you do, then good luck in opening it.

A non delimited one field file, yes. A fixed width file, i am not too sure about that. If thats what the OP wants then he has to make sure that if a field is defined as length 10 and an incoming value has only 8 bytes, he needs to cat 2 extra spaces to it to make it a truely fixed width file. A litt...

We can expect a lot more people signing up at dsxchange now. As this website is now the only website with 24/7 support.

Can be done via transformer or via some fancy sql.

Build a sequence to control the process. Your first job will get the business start date and load it to a hashed file with hardcoded key '1'. In your second job , inside the job activity, in the Value expression of the job parameter "BeginDate", right click, go to DS Transform, go to sdk, then to Ut...

Along with checkpointed restartability, you also need to set the transaction size to 15000. Then in the stage variables keep checking the @INROWNUM. The moment it crosses 15000, it can set a COMMON variable to 1, and set the counter back to 0. Each time it crosses 15000, the COMMON variable will be ...

I feel the same. Load it into two temp tables and run a sql query on it. That would be the best, IMHO, solution.

Or Read your file and load it to another sequential file with delimiter and quote character set to 000. Just a straight load.

Check out this post
http://www.dsxchange.com/viewtopic.php?t=101418

I had not seen your answer during the time i was replying. I missed it.

I apologize for my act. This shall not happen again.

Only this one time, actually for less than 14 cents a day you can become a premium member and get access to the ocean of knowledge. Highly advisable. The definition of a passive stage for your purposes is one that reads from a source or writes to a target, i.e. an I/O stage. A bit deeper definition ...

If the entire sequence, with the exception of a few jobs, needs to be run again, then the simplest way is to make a copy of that job and then change the few jobs you want to be changed.
IMHO.

Olgc, You forgot to put the ending code tag.