DSXchange

Hi : I have an excel file containing 2 different kinds of metadata. Example EmpNo EmpName 1 John Address Phone India 34534534 USA 324234234 The file contains a mixture of these kind of data. Is there any means in datastage to convert it into EmpNo EmpName Address Phone 1 John India 34534534 1 John U...

Does anyone have any experience processing MIBS-II data or other network metrics with DataStage?
(MIBS-II is a GUI that sits on top of SAS.)
--
__________________________________________________________
Sign-up for your own FREE Personalized E-mail at Mail.com
http://www.mail.com/?sr=signup

Theres nothing random about your random number if you default the seed and always base it on the same number. When I ran your code here, the random number was *always* the same... 51173053. With a default seed and always using 100, it generates the same *sequence* of random numbers: 51, 17, 30 and 5...

Tim, sorry I cant answer your question but I have one for you, we are evaluating tools to help us in the Data quality and cleansing area and one of those tools is Integrity, can you share some of your experiences with the tool? Thanks Alejandro -----Original Message----- From: Tim Walsh [mailto:tim....

1) You could pass the Job name, adding the job name to the end of the current file name. - The names will be unique from each other, but not unique from previous runs. You will need to remove the file prior to using it. 2) Add a character to an existing dummy file, performing a word count (wc -w), p...

Hello,

I know that this is mostly a DataStage list, but I want to see if any of you
all are using Integrity, or are aware of an Integrity user group.

Ive been posting some stuff out on http://www.datastagexchange.com/, but I
havent really got a response yet.

Any advice would be greatly appreciated.

Cheers,

Tim

Hi All, If I have two jobs that are scheduled at 7 AM and both call a custom routine to create an email parameter file (I have another process that sends the emails). Any tips on how I can make the email parameter files with unique file names? Ive tried adding date-time and random numbers to the fil...

Do you have the SAP Front End installed on the workstation ? -Doug -----Original Message----- From: Pasquale Vaira [mailto:pasquale.vaira@cgey.com] Sent: Wednesday, June 11, 2003 7:00 AM To: datastage-users Subject: Error during installation of DataStage Load Pack for BW Importance: High Hi Guys, I ...

Hendrik, The best way that we have found to get the real issue with the load is to use the SQL Server 2000 Profiler tool and watch for errors on that table. This will typically give you the real error number in SQL Server. Once you have the real errors number you can go to books online to get the de...

Hi Guys, I have receive this Error Message during the client installation of the DataStage Load Pack for BW on Datastage 4.2. "An error occurred during the move data process: -119 Component: Program Files File Group: ProgramDLLs File: C:Program FilesArdentDataStagedsbwgui.dll". Does anybody know why...

Here's an interesting and perhaps useful post on the DSX regarding naming conventions:

http://www.datastagexchange.com/phpBB2/ ... c.php?t=98

As a completely different solution, one that I have used, why not use the fourth argument of DSExecute, which is the exit status of the command (0 = success, non-zero = failure). For example: Shell = "UNIX" Cmd = "cat filename > /dev/null" Output = "" ExitStatus = -1 Call DSExecute(Shell, Cmd, Outpu...

SQLSTATE is a generic ODBC error code. You can find them documented with the ODBC API (presumably that exists somewhere on the Microsoft web site - I have the manual). You will probably be disappointed to hear that it decodes as "Parameter marker text size exceeds allocated space". This may mean tha...

Have you tried writing Output to the log or checking its length? I suspect it is actually a dynamic array with multiple lines. > -----Original Message----- > From: johnshot@bellatlantic.net [mailto:johnshot@bellatlantic.net] > Sent: Wednesday, June 11, 2003 2:18 AM > To: datastage-users@oliver.com >...

Sorry figured it out it is embedded LF in Unix return, we altered CMD From: *CMD=[ -s :FileArray: ] && print 1 || print 0 to *CMD=[ -s :FileArray: ] && exit 1 || exit 0 the echo and print statements were returning LF, so now we can do: if (sysreturncode) thanks John s Original Message: -------------...