DSXchange

ppalka wrote:

g_rkrish wrote: do you want check your server or your job.also pls mention your server is it windows or unix.

As you can see in post header it is unix

sorry,As kennth mentioned you can't even connect to client if you server is not running.which means you can'do anything or run DSJOB command etc.

ppalka wrote:Hi,

I want to test the state of my ds server process(engine). Is that enough to check if there is running dsrpcd process?
How to check if that process is not hanged? Execute 'dsjob' command?

do you want check your server or your job.also pls mention your server is it windows or unix.

thanks,
RK

Hai, I am new in DataStage. I have one doubt. Example Coding: Begin Case Case Count (Arg1,'a') > 0 Ans = 19 Case Count ( Arg1, 'a') = 0 Ans = 20 We are checking for the PIPE ( " | " ) in the source, if we find any PIPE inside the data like ( Sur|esh | 2345 | taj), the whole job going to b...

Hi, I have a job in which i am doing a look up with 7-8 tables(ODBC stage) all the ODBC stage has a user defined query on its own.when try running this job it is taking hell lot time like an hour.but the source table has only 9000 records.I treid running the query in the database it take only 2 seco...

Hi, We are on 7.1 and do not have report facility .......... But is there is any routine or job code to extract the info from .dsx ..would be gr88 help .. Thanks Nothing out of the box exists like that. As of v7.5 you can make a report for a single job from designer (clicking on the button looking ...

Best practice: Build your target row within DS and then either insert or update it once in the target. DB i/o is a performance killer. ... The way am doing that is Source Target 1) Column 1:L1 Column1:'Y' Column2:'XXXXX' 2) Column 1:L3 Column1:'Y' Column2:'YYYYYY' etc Like that we are doing is any ...

Best practice: Build your target row within DS and then either insert or update it once in the target. DB i/o is a performance killer. ... The way am doing that is Source Target 1) Column 1:L1 Column1:'Y' Column2:'XXXXX' 2) Column 1:L3 Column1:'Y' Column2:'YYYYYY' etc Like that we are doing is any ...

Your mail has some "holes" in it... but let's try. You need to populate a table with fields from a source, the updates have the same primary key but the logic for the calculation is different. And you can't do it in a single SQL, e.g. your groupings are different. 2 SQLs as input one tabl...

Hi, Actually i have table that need to be populated.Each of the column in the table has different business logic but with the same column in the source. I thought of doing that by populating primary keys first then updating each column one by one.Is any way in datastage that we can do that with sing...

Did you define the key values used in the WHERE clause on the reference stage? ... thanks, It works, I think the real problem was i gave a user defined query.but ideinfed the key column in the ODBC stage but i didn't specify in the reference so it was causing me that problem. thank you everybody fo...

Hi, i am trying to look up a table.when i try running that table what it does is it puts the first row value to all the rows not matter lookup found or not found. when i do the same thing using hash file it works.It looks weired.i tried running the query it works fine in the database. Can any one he...

It sounds like you are using the filename to actually store the email address. This seems a bit of an overkill. Why not just have it stored as an environmental variable and when it changes it is changed in the administrator. Thsi would only be pleasant if it changes ocasionally and not often. What ...

Cool. Set up your environmental variable in the administrator. Add the environmental variable into the properties of your job and then set the value equal to $PROJDEF. Anytime you need to change the value you just go into the administrator and change the value there and it will automatically be pic...

Go into Data Stage Administrator and then set up a variable name, something like STEWARDEMAIL. Provide a description, and set the type to string. Make the email address be whatever email you were going to put in the file. Then go to your job properties and include this environmental variable in you...

kwwilliams wrote:How dynamic, it changes with each job run? Or it can change occasionally?

not each job ru.Occasionaly it will change.