DSXchange

Hi

We have recently moved on to DataStage 8.1.
The server time on which the DS is installed and the time shown on the Directory are differing by 9 hours.

How do I sync these times.

Let me know if you need more information.

Regards,

Hi,

Need to know if we can call UNIX commands from JCL in server job.

Example: command to know if the file exists or not and then call a job.

Hi , Not to hijack the thread, I searched for post on how to prevent creating a flat file when there are no records processed. Can you direct me to one or tell me the search terms, I used lot of combinations but of no use. I am appending to a file (using ftp stage in server job) and when there are n...

Hello, I have a job where I am loading data from a flat file to a database. Flat file -> Transformer -> Db2 API Stage I know that there are 100 records in the flat file. Now I want to know how many of them are inserted into the DB2 Tables? I can get that by saying select (*) from db2.table, but how ...

Hi,

I haven't used this stage for quite some time. I am unable to refer to the input columns in the Db2 UDB API Stage.

My requirement is that, there is a primary key comprising of 3 columns, I want to update on of the column (Primary key) based on the primary key.


Regards,

First We had two servers running, one is the replica of other. We switched from Server 1 to server 2 some 1 month back. 2 Server was up and running for the past 25 days, the other was just sitting there no action was taken on that. So it had all data except the last 25 days data. Now by some means t...

Hello, We have a strange situation. We lost our jobs developed on Development server, we haven't taken the backup of the jobs. Though we had taken the back up of all the files on Unix server. Not sure if I restore my Unix Server I will get back my jobs? So my question is where are these jobs stored?...

There could me more then one occerence. Your example senario may also occer.

Hi, I have a special case where I have to replace a word from a string with a mixed case string in a field, I know before hand what are the words that needs to be replaced with some special words. I get a list of words from a Reference file as OCONNELL=OConnell LADISA=LaDisa LADOUCEUR=LaDouceur LADU...

Got the Solution thnx.

Marking it as resolved.

Hello,

When I validate the Address field I am getting the cityname along with the State Code. Which I don't need.

Is there a way to handle that.

REgards,

Hello Users, When I try to standardise the US name I get the bunch of other fields. Not sure what each one of them mean. Can any one explain when to use these fields. NameType_USNAME : ?? GenderCode_USNAME : Gives you the Gender based on the name. NamePrefix_USNAME : Gives you the Name Prefix if any...

I am sorry If I have confused you. The lookup file is like this. Code_from Code_to Name 0120 0200 Molgara 0250 0260 NewInput 00120 01999 Sreedhar I didn't sort while loading into the Lookup file set. Should I be sorting it before I load into the Lookup file set? as said above based on input "Wh...

I don't know that is the a root cause. Bez I have some other values I am getting the right output. namely 0120 - 0200 Molgara 0250-0260 NewInput 00120- 01999 Sreedhar When I send the input as 0252 I get NewInput, but the problem come only with 0120 or 0121 where insted of Molgara I am getting Sreedh...

Can you identify both boundary values for the range? For example if the lower bound is 0120 but the upper bound is 999999 then it is possible that 00120 might be the first or last key found and that ... The Range is as follow Defination : Code_from Char 5 Code_to Char 5 Name Varchar 20 the Data in ...