DSXchange

AFAIK, the Email body in the Notification Activity does not support parameters. However, if it did you could try using the DSJobController macro there - that should get you the Sequence name.

Yup. That or put that in your 'wrapper' script for dsjob that ensures everything is properly setup, environment-wise (etc etc), no matter who wants to run the job.

The latter. It's a normal convention when working with metacharacters and you escape them so they become a literal instead of being interpreted by the shell/program/parser/whatever.

Please mark the thread as Resolved using the big button at the top of the screen.

Or script them as separate steps and check exit status before going on.

Yes. No. Not officially, anyway, but sometimes you can make it work. What database? What kind of CLOB games are you thinking about playing?

(you might want to fix your Subject line)

Yah, sorry... I should have noticed the hijacking in progress but we're halfway to Cuba by now.

Well, there you go - resolved all over again.

More of an ftp problem than a DataStage one, it seems. Is it consistent?

Binary or ASCII transfer? Only read it as fixed width if each record is always a consistent, fixed size. For that you need to ensure the Display Size is the actual size of each field. Otherwise just read it as one long varchar.

Good to know!

Only if you are certain that no jobs are running at that time.

Why so worried about this?

The largest value it could be, meaning the length of the longest record type.

Very. Purging or pruning them is fine, however, as long as the job they are associated with has completed running. Typically, people script something to run every day and remove any items X days old where X is on the order of 3 to 7, I would guess.

anabi wrote:the problem is when I ran the column analysis on a sample of 100,000 records and it took nearly one and a half hour. which is too slow.

Sorry but... says who? I have no clue on the speed of that beastie or how complex what it does is, how long do you think it should have taken?

No can do, those files are essential to the proper operation of the product.