DSXchange

Hi John, I dont understand if you have primary a DataStage Problem or a UNIX-Problem. If it is UNIX: you can write a shell-script and see how it behaves. If it is DataStage: you can write a routine and see how it behaves. The Syntax you use is correct Universe Basic. If used in a routine you will fi...

Thanks for your suggestion, which also executes. However, the problem is when I perform the test which follows the cmd: IF Output 1 then Print "NOT FOUND" end else print "FOUND" End Regardless of whether the file exists or not, the test does not work. Is this because it is returning a string value a...

Hi All Im trying to load a table in SQL 2000 in Windows 2000 using DataStage 6.0r3 on windows 2000. I get the following error: LoadSilicaDDFee..Map_Data.Insert: DSD.BCIPut call to SQLExecute failed. SQL statement:INSERT INTO "SilicaDDFee"("Product", "AgentNo", "DD_Date", "Measures", "Amount", "Amoun...

Hi John, I am not able to reproduce your problem (AIX 4.3.3/DataStage 6.0.1) CMD="if (test ! -s ":FileArray"); then echo 0; else echo 1; fi " gives me a 0 and 1 back via Output and a 1 and 0 via SystemReturnCode. But why do you work with subshell and negation. Try it once the direct way: CMD=[ -s :F...

There might be a better way to do this, but I normally read the long descriptions that are located in the transform and routine objects (Built-In or SDK). You can get to them via the DS Manager or the DS Designer (v5 or later). I normally navigate by the object names or their short descriptions. I d...

Can somebody tell me why if I test for a file like this it works, but if I just echo 1 or 0 it does not? (The test IF Output or IF Output=0 doesnt parse correctly) CMD="if (test ! -s ":FileArray:"); then echo OUT0; else echo OUT1; fi " Call DSExecute("Unix",CMD,Output,SystemReturnCode) IF Output[4,1...

where do i find the information on this in the documentation? -----Original Message----- From: Tim Walsh [mailto:tim.walsh@york.com] Sent: Monday, June 09, 2003 9:46 AM To: datastage-users@oliver.com Subject: RE: sequence generator There are a lot of ways to manage unique key generation, but for sta...

There are a lot of ways to manage unique key generation, but for starters look into the following transform: transforms/sdk/KeyMgt/KeyMgtGetNextValue Enjoy, Tim -----Original Message----- From: Babatunde.Ebohon [mailto:Babatunde.Ebohon@target.com] Sent: Monday, June 09, 2003 10:33 AM To: datastage-u...

Hi all,
Does datastage have a sequence generator to create unique keys on a table? Im new to the tool.

Tunde

ALLOWNFS is a parameter in the uvconfig file in your DataStage Engine directory. If it is set to 0, which was the DataStage default prior to version 5.0 (iirc), then it is not permissible to use mounted file systems. Since then, however, ALLOWNFS has been defaulted to 1, which allows remote file sys...

>>> sbrooks@psu.edu 05/06/2003 Hi All, Is it possible to use a UNC path in a DataStage sequential stage? >>> >>> EDuroselle@seafrance.fr 06/06/2003 7:46:42 AM >>> Scott, It is possible, Im using it every day.... >>> Thanks Ed. Youre advice worked, I changed the userid in the Administrator / Schedule...

Scott, It is possible, Im using it every day. Your problem is most certainly a Windows permissions problem, because the default user for DS jobs is usually "localsystem", which has _no_ network rights. You must set up a windows user with the necessary rights in the NT domain to access Servernameshar...

What version of DataStage? What is the value of your ALLOWNFS configuration parameter? ----- Original Message ----- From: "Scott Brooks" Date: Thu, 05 Jun 2003 15:53:00 -0400 To: Subject: Question using UNC paths > Hi All, > > Is it possible to use a UNC path in a DataStage sequential stage? > > Det...

Hi All, Is it possible to use a UNC path in a DataStage sequential stage? Detail: Im on an NT 4.0 server and would like to read a file from another server using the Universal Naming Convention (UNC), such as ServerNameShareDirInputFile.txt Currently for testing I have the share wide open with permis...

Since the rerun of the job worked, the catalog space (ie catdir) is intact and working, and a reinstall of DataStage will garner you nothing. Additionally, while it is possible that someone changed permissions on it (or a specific file within), youd have to be either root or dsadm to do such, since ...