Thanks Ray and Jwiles.
echo $ISUSER worked
Ray I did not quite understand what you wanted me to do with the id command when I run that on unix it gives me the below output
jwiles that a very elegant way of doing it through $ENV
Search found 48 matches
- Wed Mar 16, 2011 11:38 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: GetEnvironment("ISUSER") in Sequencer
- Replies: 6
- Views: 6367
- Tue Mar 15, 2011 10:47 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: GetEnvironment("ISUSER") in Sequencer
- Replies: 6
- Views: 6367
GetEnvironment() is only available in parallel jobs. Please perform this test. In an Execute Command activity in a sequence execute the id command to find out the user that actually runs yo ... I am using parallel jobs. In the director logs I do see that ISUSER has my login id but I cannot get it i...
- Tue Mar 15, 2011 10:38 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: GetEnvironment("ISUSER") in Sequencer
- Replies: 6
- Views: 6367
GetEnvironment("ISUSER") in Sequencer
Is it possible to get the userid of the person running a sequencer "GetEnvironment("ISUSER")" this works in a job but when I tried using this in USERVARIABLE in a Sequencer Job the job wouldn't compile. My question how can i get the USER in a sequencer @LOGNAME gives me the dsadm...
- Mon Nov 01, 2010 3:36 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Multiple SQL in Before/Afer sql
- Replies: 3
- Views: 2060
Re: Multiple SQL in Before/Afer sql
Yes you can separate them with ";"
- Sat Aug 28, 2010 3:32 am
- Forum: General
- Topic: SQL Server - Win NT Authentication
- Replies: 2
- Views: 2303
SQL Server - Win NT Authentication
Is it possible to logon to a SQL Server DB using Windows Authentication this is what I have in my .odbc.ini and it doesn't work [MARS08062010] Driver=/opt/is/IBM/InformationServer/Server/branded_odbc/lib/VMmsss23.so Description=DataDirect SQL Server Wire Protocol driver Database=MARS08062010 LogonID...
- Wed Jul 14, 2010 3:06 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: MULTIPLE SQL SERVER DATABASES ODBC.INI SETTING
- Replies: 7
- Views: 6824
A non datastage person (EX SQL Server DBA) provided the solution. We created one SQLSERVER connection in the .odbc.ini file and the jobs connect using that DSN and in the BEFORE SQL of the ODBC stage we are switching the database using the SQL command USE <SQL Server DB NAME> ** and prefix the table...
- Tue Jul 13, 2010 11:12 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: MULTIPLE SQL SERVER DATABASES ODBC.INI SETTING
- Replies: 7
- Views: 6824
I am at the end of my wits. The only way that I can think of is to change the .odbc.ini file at run-time (I personally dont like that idea as it might lead to more complications with multiple instances and other applications that might be using the same datastage project) Will ask IBM and see if the...
- Tue Jul 13, 2010 10:02 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: MULTIPLE SQL SERVER DATABASES ODBC.INI SETTING
- Replies: 7
- Views: 6824
- Tue Jul 13, 2010 7:48 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: MULTIPLE SQL SERVER DATABASES ODBC.INI SETTING
- Replies: 7
- Views: 6824
MULTIPLE SQL SERVER DATABASES ODBC.INI SETTING
Is it possible to access multiple SQL Server Databases running on the same server with a generic .odbc.ini setting. My requirements does not allow me to create new entry into the .ODBC.INI file for every database in the server. Here is a working .ODBC.INI file that has 2 entries going into the same ...
- Wed Jun 30, 2010 9:21 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Search for a string
- Replies: 2
- Views: 1795
Search for a string
Friends, I have a requirement where I need to build a complicated investigation output. My Source file has 2 fields Source File I: Acctno, Acctstyl -------------------- 1, john doe and MARY DOE DBA DOE Garage 2, Andrew Watkins TRUST account 3, ABC Consulting Inc Account Source File II: SEARCH WORD -...
- Fri Jan 08, 2010 7:32 am
- Forum: IBM QualityStage
- Topic: Matching Help
- Replies: 3
- Views: 2267
- Thu Jan 07, 2010 11:25 pm
- Forum: IBM QualityStage
- Topic: Matching Help
- Replies: 3
- Views: 2267
Matching Help
I am trying to create an output like GROUP, ACCOUNT, KEYWORD 1, A1, HOLLAND 1, A1, DENMARK 2, A2, TRENTON 3, A3, WISCONSIN 2, A4, NEW YORK 2, A4, CALIFORNIA 2, A4, TRENTON 4, A5, DENVER 1, A6, HOLLAND Where the input fields are Account and Keyword and the GROUP is generated by matching job. As you c...
- Wed Dec 23, 2009 7:34 pm
- Forum: IBM QualityStage
- Topic: REMOVE DUPLICATE WORDS
- Replies: 9
- Views: 5275
DBA = Doing Business As there are a lot of other keywords like DBA embeded in the data. What I am trying to do is remove all the first names and middle names and all the known keywords (like DBA/POD) and have a list of unknown words and also eliminate the duplicate words and then try to create a LOO...
- Tue Dec 22, 2009 3:52 pm
- Forum: IBM QualityStage
- Topic: REMOVE DUPLICATE WORDS
- Replies: 9
- Views: 5275
- Tue Dec 22, 2009 3:01 pm
- Forum: IBM QualityStage
- Topic: REMOVE DUPLICATE WORDS
- Replies: 9
- Views: 5275
REMOVE DUPLICATE WORDS
how do I remove words that are repeated more than once in a string Example : Input : JOHN DOE AND MARY DOE DBA JOHN INC Output : JOHN DOE AND MARY DBA INC Right now I am using DataStage to split all words and then get unique values was wondering if there was a simple way to do this in QualityStage w...