DSXchange

krishna410 wrote:Latest version in datastage..

And what are the new features between 7x and 8x.

Thanks&Advance,
Krishna.

IBM is offering a course which outlines the new features in 8x. I addition, you can read alot ofdocumentation and links in documentation explains new features.

Hi All, I have to give one condition in transformer. I am using a stage variable to do this.But the job is getting aborted because of that particular condition.I am not able to find out whats wrong in the below condition. If Trim(Move_Xfm.Make)='Chevrolet' And Trim(Move_Xfm.Model)='Impala' And Trim...

chandra wrote:How to execute this comands DSGetProjectList,DSGetLinkInfo,dsjobrun,APT_DUMP_SCORE.
please gice one brefie example .

Thanks in Adv

APT_DUMP_SCORE is effective for showing job score in DS run logs. APT_DUMP_SCORE can be set at environment level and/or job level( as environment variable) also.

How to execute this comands DSGetProjectList,DSGetLinkInfo,dsjobrun,APT_DUMP_SCORE. please gice one brefie example . Thanks in Adv dsjob is command line utility. use dsjob with -lprojects and -llinks, -linkinfo options provide you what you are looking for. You can find dsjob in $DSHOME/bin DSGet* m...

We have DS runnig in Unix Env. and I have a job that I need to schedule through a dot net web application. I don't want it to run it right away rather let user choose a date through the web and I want to schedule this job on that date after hours. I want to automate it. My question is what interfac...

I have a fixed width flat file containing a field with character data type, such as, ab dfa adfa adie ab dsf dfe adf abe I have a lookup flat file which contains just one character field, such as, ab do so I need to pull out those records which contain strings from lookup file. And I need to be abl...

It is advisable to generate sequence number and use in naming convensions for file name in "appropriate location". Also extract return code from mesage body for further filtering and error handling purposes, if you have that requirement.

If you let server upgrade process do upgade process, all projects on server will be backed up upgade process by exporting projects and other components, but not executables. If you include executables in manual process, these happened to me also.

Sree

Ray, Fortunately or unfortunately We need to add Recruiters also to Lawyers, Clerics and pliticians. Probably Rowan Atkinson don't have experience with them. :D :D

Sree

You have work around for this being used by our gurus over years in UNIX with Awk and perl. Develop scripts in such away to take meta data file ( contains field name and definitions) . Use one metadata file per file you want to process. Your main script should read that metadata file and use that in...

Do you have location of db2nodes.config file part of PATH and LIBPATH in dsenv file? ?( not sure but definitely either PATH or LIBPATH) If not you will receive this mesage. If you have, you need to check your licensing of DataStage to work with DB2. (DB2 DPF with multiple nodes on different boxes de...

abc123 wrote:Actually, I wanted the columns from input tab moved to the output tab at design time. It doesn't happen. How do I get the columns moved at design time without manually typing them?

enable runtime column propagation for the job.

Sree

Raftsman wrote:Can someone please tell me the command I could use to cleanly delete datasets.

Thanks.

Use orchadmin utility at command line to delete, copy, describe datasets. Other wise use tools/dataset amangement in manager to manage the datasets.

Sree

Raftsman wrote:Can someone please tell me the command I could use to cleanly delete datasets.

Thanks.

Use orchadmin utility at command line to delete, copy, descrinbe datasets. Other wise use tools/dataset amangement in manager to manage the datasets.

Sree

chulett wrote: Someone else would have to answer that. Server jobs, sure, but I couldn't say for certain about PX. I would imagine you could, but... [shrug]

MQ available in both server and PX jobs.