DSXchange

I played with tis task before and came up with the following code: Call DSGetLinkMetaData(Result, JobName, StageName, LinkName) print "JobName = ":JobName print "LinkName = ":LinkName print "Result =":Result print "StageName = ":StageName print Result<1,1> pri...

I do not think you can use # for delimiting parameter name in BASIC routine. For example in job control it does not read variable if you use #varname# but works fine with just varname.

You can do it with Unix script.
Something like that:

Check the job status with the invocation id. You can decide the result upon the return. I tried it. Return code is still 0 but the output gives something ward /etl/test/scripts$ dsjob -jobinfo galaxy MyJob.AA Job Status : NOT RUNNING (99) Job Controller : not available Job Start Time : Thu Feb 17 1...

I have the following problem. I am retrieving the link info from the multiple instance job. Code in UNIX script is as follows dsjob -linkinfo $DSproject $DSjob.$parmTypCd$dtTypCd $DSTransform $DSLink>$linkInfoFile 2>&1 rc=$? if (($rc != 0)) then cat $linkInfoFile rm $linkInfoFile print ABORT WIT...

The way it is described it sounds like the same old problem with TRUENUMERICS setting. It is set to 15 by default and the DataStage is not able to process larger integers. So the suggestion will be to increase the TRUENUMERIC value let's say to 20. Just search the forums for directions. BUT. As did ...

I don't think that's supported in DataStage, it will try to use the fields user id and password whether you fill it in or not. If DataStage did a more general authorization you could get e.g. Oracle and DB2 to work on the local machine without passwords. Ogmios It does work with our DS installation...

Back to the original question.
What is the opinion about not using user id and password for Database access at all. I mean living the fields blank and let DataStage accuire id and password of the user who initiate the job

You can have a master control job that reads from an ini file for the values and attaches to a job (name being a parameter to the master) and set the parameters as found necessary in the job. Thanks. But I am working with UNIX server. I can read a protected file but when I pass the password value t...

Only if you use the dsjob program to set parameters and run jobs. If you build your own job control using a Batch job, Sequencer, or custom job control, you have the ability to fetch parameter values and directly control the setting and running of jobs. We are using dsjob program. Password must be ...

This is all nice and dandy. I love parameters. But the password is a different animal. It is a security issue. If hard codded in the job then it is masked. Yet passed as a perameter value it is open to everybody who can ps -ef the processes.
Any ideas?

Another trick. Also a little involved: 1. Unload your hash file into flat file format same as the input file. 2. Concatenate input file to this unload file (input file last). 3. Load the result into new hash file with the key to eliminate duplicates(this will keep input file row where it duplicates ...

Just an idea: The missing argument may be a stage name. But it is for you to figure out in what position to put it.
I had similar problem with the other function. Documentation was incorrect.

Logically it can be done by removing a quote character not followed by comma. I am not too fluent in regular expressions but I believe it can be coded. Of course if you have the ", combination inside the field then there is no way you can recognize it.
Therefore Ray is right - GIGO.

I am new to PX and being used to have "First line is column names" setting in DS Server.
Is there such setting in PX sequential fies?