DSXchange

The last update for 3K post is on Jan 25th, and now on 4K.
Great job!!!!
Way to go...

ray.wurlod wrote::!: Briak Kernighan is the "k" in "awk" - Aho, Weinberg and Kernighan.

Interesting

No, you cannot do many things. Compilation is a function done by the compiler which resides in the Server. You can just install client in your PC. If you are looking for some stages, you can install it from your client CD. First of all, the stages to communicate, it should have a server in unix. Say...

7.5x2 is the only Windows supported in Datastage as of now.

Would you mind marking the topic as resolved.

The schema name that you have specified in the designer is not available in tnsnames.ora. If you are passing it as any parameter, check it by hardcoding it.

No, not available in Database stages.

Peek is to check if the output from row gen is as expected.

Or
Peek
^
|
row gen---copy--xml input--dataset?

I tested with the same input "00:/9:10", it gave me the output as 1. Pls do change and Hr >=00 rather than and Hr >=01 (typo).

Use Peek stage next to Row generator to check the values that been output. But the way, Folder stage is not analogous to Row Generator in PX?

Under the General Tab, you might use Filter command to this, are you using /dev/null in "File Name" option?

You can use different stages in same job, but not different metedata in same Stage at runtime. Datastage is Metadata driven, hence, you need to specify the metadata will before the job is complied. There are few option like schema file and RCP, where you can have flexibility to change the Metadata.

There is, but you should have done a search before that. Last date of the previous month - DateFromDaysSince(-1, StringToDate(RUN_DT, "%yyyy%mm") : "%yyyy-%mm-%dd") And First day of the previous month - StringToDate('01':MonthFromDate(RUN_DT,"yyyy%mm%...

Instead of >- use >=. Hr <24 and Hr >=01 and Mn<60 and Mn >=0 and Sc <60 and Sc >=0 Yes, Iconv is actually converting the given input values into valid time. The input 25:60:60 is getting converted into 02:01:00. The hour greater that 24 is added to next day and minute to next hour. MTS can be use f...