DSXchange

Given in the previous post.

...using a TCL command(Exec TCL) in a before-job subroutines...

If you are trying to install both server and client on you laptop, you can easily find the services in Control Panel. Ascential logo. Stop all the services. Else uninstall the existing partial installation and do a clean reinstallation.

Hi Sameena,
Check right-click and draw a reject link to the sequential file stage.
What stops you from using DB2 Enterprise stage stage, where you have option to collect the reject records and the reject code.

If you issue is resolved, mind caring to mark it as resovled.

Environmental variable are usually called as #$envVariable#

In what aspect you are looking for?
As mentioned
hashed file - server jobs
Dataset - PX jobs.
Data are stored in Datastage internal formate in Dataset. Data are hashed based on the key specified in Hashed file.

There is not provision of sending SMS from Datastage directly.
But if your mail server supports, its possible. Mobilenumber@yourmailserver.com

Does your input file have data with the same metadata? Did you import the metadata using sequential file? Check if your filepath and file name are pointing to the exact location. Is your server on windows?

Not in transformer, but using either Sort or Aggregator stage. You can group based on 'name' and find the max of 'no'.

The parent sequence can capture that the child sequence is aborted, but not the detail log. You need to have individual ExceptionHandlers to capture the log. But if you want to have a centralized Notification, you can do some workaround like, writing the individual log to a file at particular path, ...

Check for all the parameters for DB name, user id, password. Try to import metadata from Database, it will give you the information on connectivity to the database.

I don't have access to PX, but you can convert it using database stage by TO_CHAR(SYSDATE,'Month DD,YYYY').

What you exactly mean down time and uptime? If Datastage is down, you cant expect the universe tables to be updated. Or do you need the timestamp of Datastage engine stop and start? Even its not recorded, as far as I have noticed.

Is it still Unix?
Otherwise Prepopulate into fileset and do a lookup.

Hi Fiona,
Welcome to Dsxchange!!! :D
Universe commands are not documented in DataStage pdf. But you can find under IBM site where Balaji has pointed to. Most of the useful commands were discussed here. If you do a search, you can find it.