DSXchange

Thanks ArndW very much for sharing information, we will install client mail application on DS server and will test the same.

Thanks ArndW for quick reply. I had tried using searching criteria and found 7081 post, but unable to find suitable solution for my issue. If anyone of you have any reference of previous post on same, kindly let me know. Ray: Thanks, client machine has been rebooted many times. Yes I am using Window...

Can I use some other email server as proxy server for our DS server ?
That means If I install client version of mail application(in my case Novell Groupwise) on DS Server, will I be able to send email notification?

or Should I need to install server version of mail application on DS server?

Hi, Our DS server does not access email server in the network, i.e no client email software is installed in Ds server. What is the minimum requirement for DS server to send email using Notification Acitivity? Please note groupwise mail is installed in some system in the network(don't know where it i...

Hi, I am facing one problem. While adding any activity and link to one another, I can't open property of the activity. For some activities(like startloop_activity,endloop_activity) with no link with it, I can open the properties. The momemnt I create a link on it, I can't open the property. For othe...

My requirement is to get all jobs names and their corresponding job category name, and job depenency in formatted output from current datastage project. I have create one test job where using DSGetProjectInfo (DSJ.JOBLIST), but I got only job list in the current project. Any hints or help will be gr...

1. In job properties of sequence check Add checkpoints so sequence is restartable on failure

2. Add a link of terminator activity at job B, select in properties of terminator activity as Abort without sending STOP request.

So in your case job C will still run even though job B fails

Hi, I tested following scenario and got result which is perferctly fine for me. Ans=Trim(Arg1,'x','B') Arg1 = xxxxxxxxxAAAAAAAxxxxxBBBBBBBBBBxxxxxxxx Result = AAAAAAAxxxxxBBBBBBBBBB ------------------------------------------- Ans=Trim(Arg1,'x','L') Arg1 = xxxxxxxxxAAAAAAAxxxxxBBBBBBBBBBxxxxxxxx Resu...

The parameter and default values are stored in DataStage Administrator's under project properties-->environment. What you are getting using $PROJDEF are all environment variable defined in DataStage Administrator. While running job using dsjob command, you can send local values instead of defult val...

chulett wrote:No, it will just be informational. Here, one from my logs:

Code: Select all

Project:XXX
Job name:YYYY
Event #:3187
Timestamp:5/27/2007 9:56:28 AM
Event type:Info
User:dsuser
Message:
Job.Link.HashedFileName: Read caching disabled, file size exceeds cache size

Thanks a lot Craig!

for leap year u need to check year first for leap year like following:

transaction size: is no. of rows written before each commit. u can give default value is 0 for if input size is less, that is, all the rows are written before being committed to the data table. If ur input size is too big, u can specify let's say 10,000. it all depends on ur requirement how u r goin...

mouthou : Are you sure you were able to create the table ? But when I tried to run your query CREATE TABLE user2/DBAPVEN1(VENDOR_GROUP CHAR(4) NOT NULL, VENDOR CHAR(9) NOT NULL PRIMARY KEY) but i got following error SQL0104N An unexpected token "/" was found following "CREATE TABLE us...

Thanks everyone for valuable input!

Craig: Will it give error message or warning message if data can not fit in the memory, if I set Pre-load file to Memory-Enabled ?

The setting you mentioned will be used when you need the link private caching facility. More details are found in the Disk Caching Guide. Problem is , you rarely can predict the size of a hashed file that you will use. Ramesh: Can you please explain little bit more about link private caching facili...