DSXchange

Yes, there are other advantages but the one I mentioned is what I feel has the most impact on development.

Imagine having 100 jobs and having to add a parameter to each one (perhaps $APT_DUMP_SCORE or the like). With a parameter set you declare the set once and then use it in jobs, if you add a new parameter all you need to do is recompile your jobs.

Glad to hear you found it!

I flew into town on Saturday, picked up my bike in Chesterfield and skipped by your exit on my way to the ferry at Hull. If I'd had more time I would had given you a buzz.

Hello Steve,

I like the tag line!

Were the jobs both compiled by the same user on the machine you are trying to debug? I think that when jobs without sources are imported they might not run in debug mode.

ag_ram - I have a doubt. You stated that you can export jobs (whether just one or a whole project) and import them into another project using uvbackup and uvrestore . I am asking you to prove this. For example, I have a job called "Test" and would like to copy this to another machine. Please describ...

ag_ram - I wish I could make sense of your post. If I read it correctly, you assert that that the dscmdexport and dscmdimport (client-side) commands are not to be used to move jobs from one project to another, but that you were correct in recommending to the original poster that uvbackup & uvres...

The partition will remain the same until you explicitly change the partitioning method; i.e. the default will be "same".

The most common method to do this kind of work would be to write a template example job, then do a DataStage export to either XML or .ds format and write a job or a program to read this file and change those elements around that are different and create 100 jobs this way.

Is the DB2 plugin on your designer canvas? I can't recall if you had to specify DB2 explicitly during the installation process at V7. The settings you posted look correct, though.

The dsadmin command is not for project import and export. Unfortunately, the uvbackup and uvrestore programs won't do that either. These commands are the DataStage Engine (well, UV Engine) commands to do the equivalent of a UNIX tar . If you wish to export your project without using the clients, you...

Why not just use LEN({string}) before doing the conversion to hex?

Step by step:

1. What changes did you make to the "dsenv" file?
2. Can you issue a UNIX level "db2 connect ..." statement?
3. What method did you use to import from DB2?

It will be displayed as 2 bytes per character unless you are using NLS

ag_ram - Please don't completely delete or edit incorrect posts. If you make mistakes, update the post with the correct information, but leave the original there. That is the only professional and correct way to behave in forums such as this one.

The UserId can be retrieved simply by using the @LOGNAME in a job Sequence, then passed to the PX Job as a parameter.