DSXchange

Oh, and please don't duplicate posts!

What routine are you calling and how many parameters does it have?

mini - welcome to DSXchange. Please don't use "urgent" in that context, this site is not a replacement for a service contract but is to be used as an adjunct. If you enter your account, userid and password in the client tool, then click on the drop-down box for the project do you get a list or an er...

I would use the UNIX command "split" to do this.

adesanyaa wrote:...but was having problems to export and import between the two environments...

Unless you tell us what problems you actually had it is going to be impossible to assist.

BalageBaju wrote:##W TBLD 000000 10:16:02(011) <main_program> Error when checking composite operator: Output from subprocess: cxx: file 'C:/PROGRA~1/MKSTOO~1/etc/cxx.ccg': The system cannot find the file specified.

Looks like a missing or incorrectly set up C++ compiler.

The Server edition has a set of powerful functions, OCONV and ICONV that, among other things, converts all sorts of date formats. I would use the @DATE function to get the current date, then convert using something like OCONV(@DATE,"D4/YMD") to get today's date as YYYY/MM/DD

Actually, %MMM means that the month is in 3 digit text format (i.e. "JAN","FEB")

These are SQL queries on the DataStage engine, done either throught the TCL or from the command line utility in the Administrator.

the format string has to match exactly, if you are doing an implicit conversion of month 2 to a string you get '2', which isn't the format '02' which the conversion requires. I don't thnk that the builtin conversions put leading zeroes in and don't have the docs handy to check. But do something like...

Could you be kind enough to tell us what the error is?

No, that isn't always teh case. But here your are trimming the amount of data transferred from the DB to DataStage and thus probably speed things up. The "Trim" is going to take about the same amount of time on both ends.

Rename the folder projects. Create empty projects and then copy the contents of the renamed projects into those directories. NB This simplified approach will only work correctly if the absolute paths are identical on the old and the new machines.

"dsjob -jobinfo {project]} {job}", then parse the "Job Status" out for the main sequence. Always use the "reset if required" option in the Job Activity stage when starting jobs from sequences.

There are many ways to do this. Create a job sequence that is called from the scheduler that loops to call the job; it checks the time and once past 6am it exits the loop and stops. Or you can schedule the job to run every 5 minutes in the scheduler (assuming it runs < 5 minutes) between the 3am and...