DSXchange

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

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...

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...

Yes you can separate them with ";"

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...

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...

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...

Isnt there a way to pass the DSN name and database name as a string parameter to the ODBC Stage ???

Like
DSNNAME@DBNAME

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 ...

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 -...

I don't understand your algorithm. :? What is it that gets NEW YORK and CALIFORNIA grouped with TRENTON ? Does "group" here mean the same thing as a "block" in QualityStage match - a set of po ... NEW YORK, CALIFORNIA AND TRENTON are the same account "A4" and there is ...

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...

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...

Thanks Ray/Rod I dont have much control over sorce data so I cannot CLASSIFY it. I think I will keep typing the PAL solution since there doesn't seems to be an easy way out

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...