DSXchange

Ray,

if you need it in the same job again, the only chance is to pass it after Job1 to Job2 and then next time you need it again in Job1 fetch it from Job2 where you have parked it.

Wolfgang

Hi Ray, I don't realy yet understand your Problem, so I write something about the function you use, where I am assuming, that you know this details already. Let us assume you have a Job1 and a Job2. In Job1 you have anywhere the function DSSetUserStatus("It is a nice day") When you have in...

Remember Kamal, that you generaly have mostly 3 different kind of information: - environment information which change with your environment (Development, Test, Integration and Production - general parameters , which change very rarly - daily changing parameters like actual Jobname, actual date and s...

There are some rules, how to do it and it will work. Wheter you read the manual or tell us your command, so that we can help you.

Wolfgang

Ray, I have made the experience with DS 5.2, that when I have more than one target system and I define it globaly, that I get all the choice when I first enter a certain project. But when I then do something as for example importing metadata via one of my many sources DS does automaticly make a loca...

Hi JB, In a sequence you have normaly numers adding each time a 1 to the sequence after asking the sequence. It is a good mean and often used to control datawarehouse-loading-jobs with DataStage. An other mean instead of sequences is to use dates instead for to have a control criteria. Both means ar...

A way to keep your routines and to make the process a bit faster is to write a special job or part of a job where you have flat file as input and flat file as output.

And don't forget to reengeneer you routines the way Ray Wurlod sugests.

Hello Ranjan, you are mixing 2 things. The pivot stage is something for pivoting. As you know excel it is about the same. If you have a table like this: Name Month Sum John 04 2000 Paul 04 3000 John 05 1500 Pete 04 3400 Paul 05 6000 pete 05 5600 and you want to make a table like this: Name SumMonth0...

Hi Ranjan, if you are on a Windows-DataStage-Server you "can" use the ODBC for Excel. But pay attention: Excel is a very flexible tool. And if your users don't pay attention on the rule for db-compatiblity your buy a lot of problems. So the way you do it via sequential files is best for ex...

Hi Srinivasb, I am not in office. But you are right it is not easy to configure ODBC. If you follow all steps in a correct manner as described in the manual you will succeed. You have to look also into the dsenv-file and several other files. End of next week I am back in office an then I tell you th...

3 years ago, when we started with DataStage there was no Version Control available an though we also had several shell-scripts and sql-scripts in our project we decided to take PVCS. For the complicated manual process transfering jobs, routines and transforms from and to DataStage we have written a ...

Hi Ray, you are right. You are not only reasonably generous, you are already altruistic. Even on weekends and on holidays you spend a lot of time for to answer so many questions even those which concern only rtfm-errors. I apriciated your help very much. Each of your answers are high quality. I thin...

Sakar, craig is right. DataStage is a Tool to transfer Data on a permanent and frequent basis including a certain transformation. In doing this DataStage is a very good an flexible Tool. For to transfer Tables as they are and only once you should simply copy them. Your problem will be the Stored pro...

When adresses are concerned best is to use an adress check tool than coding something yourself. Every national or international Postal Service can name you software or services. This method has two advantages: (1) When you use this adresses for realy sending out letter and parcels or using it with G...

Hi little hope,

"chen" at the end of a word in german means little.

Siply read the docu about dsjob and you see all details. One problem is whem job run longer than an our you may get jobstatus 141, which is no error.

Wolfgang