DSXchange

DataStage 4.2 now enforces the user-limit on client licenses. It took several tries, but now clients and universe TCL prompts are managed by the user-limit. -Ken stissot@yahoo.com on 23-Jul-2001 07:27 Please respond to datastage-users@oliver.com To: datastage-users cc: Subject: Re: Licensing Issue G...

If I have already asked this please forgive. Sent to old Mail List last week and wasnt sure it got out: Anyone have experiences Good/Bad/Indifferent to getting MetaStage working properly in a Unix Environment? We have the old NT MetaStage but were not ever able to get it to work successfully. We gav...

Try to remove the trailing semi-column. Here we were calling a function (returning max(sales_id)+1 for instance) this way: insert into mytable (id, field1, field2) values (myfunction(),:1,:2) The :1 is the first datastage column of the link... Regards, Steph. --- derick j JOSE wrote: > Hello everyon...

We did not met the problem here as each of our developers have one licence... It should be the only solution... Regards, Steph. --- Jack Luchjenbroers wrote: > Hi, all > > I have a client that has upgraded from Datastage 4.0 to 4.2. > > Now that they have upgraded it does not allow more than 2 Devel...

Hi, all I have a client that has upgraded from Datastage 4.0 to 4.2. Now that they have upgraded it does not allow more than 2 Developers to access the system at one time. Is this right? I have followed datastage since 3.6 and never before seen a Developer restriction enforced and believed that it w...

Hello everyone , How do I invoke a Oracle PL-SQL procedure using an Oci stage ? The manual says -------------------- For each stmt terminate it with a semi colon Do not use a trailing semi colon What we did : ------------------- The statement was given in user defined SQL update sku_Table set dsc=12...

Hi, I wanna write large volumn data to hashed file for lookup (average length 76bytes, rocord count 24million record(24000000), But I get the problem, so many times need to arrange hashed file. when I load data to hashed file, arrange data by every 800000 record processing, without arranging data, p...

Hi all,
I am using sqlbulkloader stage, is there a way I can alter the Oracle session in DataStage to enable the parallel DMA, can I control or alter the Oracle session in DataStage. Has anyone done this before. Can anyone help
>

Bob, Ill try the abbreviated answer. If you need more info, let me know. Using Oracle sequences. The approach you are using is fine. Alternatively, you could use a reference link to get the sequence value. It to would require a user defined query, although it does not involve dates. The user defined...

Ive worked through several issues with tech. support, some successfully, some not so, with use of User defined SQL(UDS). Im running Datastage 4.0 on Sun/Solaris. I use UDS in situations with Oracle 8 OCI where I need to populate synthetic keys with sequence values. Ive used Datastages key processing...

Hi everyone!! I have problem connecting my DataStage 4.0 on HP-UX to a SQL Server 2000 by ODBC driver. Ive configurated it correctly (I hope!!!), defining: - in dsenv file the ODBCINI environment variable; - in $unhome/.odbc.ini the [dsnname], the Driver with the path to VMmsss15.sl and the Address ...

Do you log these issues with support, or simply use this list as your personal support group? The error message is perfectly clear; your Foxpro table has at least one data type that is not supported by DataStage. It is clearly the data type of the column D.XMY, since this is the only column you are ...

I have been asked to post this to the list by our HR person. Position: Programmer/Analyst Financial company located at Lake of the Ozarks is looking for a career-minded individual with a minimum of two years programming experience using one or more of the following application languages: UniVerse, U...

Ouch. Dont like the look of that. Did you use Manager to import the metadata from the table via ODBC? What version of the FoxPro ODBC driver are you using? Is it the latest? I have seen different versions of this driver return different metadata form the same source file/table. David Barham Informat...

> Dear all, > > Im getting the following error on use of an ODBC stage for foxpro, I > pass the tablename "D" as the parameter to the job. > > FolderRD.HLLMST.source: DSD.BCIOpenR call to SQLExecDirect failed. > Statement was:SELECT D.XMY, D.XMY FROM D SQLSTATE=S1004, DBMS.CODE=0 > [Ardent][SQL Clie...