DSXchange

Kumar, editing the UV.ACCOUNT should be sufficient. What happens if you try a "LOGTO Project2"? It sounds like your changing the values in the editor didn't quite work correctly.

Yes, you can do this with your 7.5 version. The instructions on how to set this up and prepare your machine are in the installation guide.

This thread also discusses doing this.

I thought of using the @RECORD, but realized that if there are a lot of files and mixes of files without VOC pointers then that approach is more work. But a simple hash file record lookup routine, using COMMON for the file pointer and passing in the record key for the READ and subsequent conversion ...

The code for jobs resides in the project directory, spread across several files. Whether the job is scheduled or not makes no difference. The scheduling information for a job is stored in the crontab file on your system. The scheduler will use dsjob to start the datastage job at the given time with ...

On UNIX look at cron and crontabs.

Wagner, there is a reason behind the premium posting. I am sure someone else will paraphrase what I said or come up with a better alternative. I think for people working with DataStage the premium membership is well worth it - let's assume as a computer professional you are getting paid $50 a day. T...

If you correctly used the table column layout in the Manager you can right-click on that to see which jobs used those definitions. You could also do a search in a full project .DSX export file for the hashed file name and then look up a couple of lines to get the corresponding job name. If you used ...

The DS_IMPORTDSX is a verb in the VOC file of an existing DataStage project. As far as I know this helper verb is not meant to be called by us and is not documented.

DSguru2b - if only it were that easy. Note that the original poster stated that the hashed files have different formats and that he/she wishes to make a generic job. What can be done is to use the fact that hashed files are not directly connected to their DDL as is the case with the normal SQL datab...

Lohith, the code you have written is in the routines part of the repository and is only accessible from Server jobs, or from BASIC transfrom stages in Parallel jobs. In addition, the code uses undocumented internal COMMON block values that might change in the future, so the routine might stop workin...

If you cut the command length down to half, does it work?

Papan, when you see the prompt that states the account is not setup for DataStage do not say "yes" - it will add the minimum number of hashed files to that UNIX directory to make a valid UV account but it does not create a valid project directory. The question is how you logically got from using dsc...

Kris, sporadic problems like this are most likely caused by a bug in the designer. If you have a reproduceable test case then you should go through your support provider to get this put in as an ecase. There isn't much that can be done here - but fortunately the next person to get the same issue wil...

To add to or complete what kumar stated execut the following: cd `cat /.dshome` . ./dsenv bin/dssh you should get a ">" prompt and can exit back to UNIX with the command QUIT . Not all installations/userid have the $DSHOME initialized upon login, and the same applies to the user environment set with...

Purchase DirectConnect from DataDirect for UNIX.