Search found 7201 matches

by admin
Mon Jan 27, 2003 1:47 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: How to Avoid Users from Sign on to Datastage clients during
Replies: 1
Views: 435

Change the Developer group in the Administrator to Operator. Leave your backup group separate. It wont stop people who are already logged in. Lamont -----Original Message----- From: Surendranath Gujjala [mailto:Surendranath.Gujjala@Ingenix.com] Sent: Friday, January 24, 2003 8:11 AM To: Datastagegro...
by admin
Mon Jan 27, 2003 1:29 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: Making job control and re-runs work
Replies: 1
Views: 507

Making job control and re-runs work

Hi, Im trying to put some logic into my job control, but cant seem to make it work the way I want it to. I have a sequence of sequences and jobs, and now i would like to be able to re-start the job, and more or less make it continue where it failed the last time. What i had in mind was that every jo...
by admin
Mon Jan 27, 2003 5:29 am
Forum: Archive of DataStage Users@Oliver.com
Topic: Connecting to MS SQL Server 2000
Replies: 6
Views: 2393

Hi all, Thanks for the information. Shall perform further test. With Best Regards, William Kenneth Bland wrote: > William, I also had to be case specific as to the > configuration parameters, namely ADDRESS and DATABASE > while on Solaris 2.8 DS 5.1. > > Good luck! > -Ken > > Ex: > [ECACSQL01] > Dri...
by admin
Sun Jan 26, 2003 9:59 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: clearing log without viewing log [1]
Replies: 3
Views: 529

You can clear the job log from Status view in Director. Others will give you advice about using CLEAR.FILE - dont, because this rubs out control records too, so you lose the event counter, your auto-purge settings and so on. It CAN be done from the TCL prompt (or the Administrator clients Command wi...
by admin
Sun Jan 26, 2003 3:56 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: clearing log without viewing log [1]
Replies: 3
Views: 529

Yes, you can. In Job Status view of Directory, just click on Job menu and select Clear Log. Take Care. Le -----Original Message----- From: Denzil Sander [mailto:DenzilS@mxgroup.co.za] Sent: Sunday, January 26, 2003 9:17 AM To: Datastage (datastage-users@oliver.com) Subject: clearing log without view...
by admin
Sun Jan 26, 2003 3:17 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: clearing log without viewing log [1]
Replies: 3
Views: 529

clearing log without viewing log [1]

Hi all

Is there a way (ie, from command prompt) to clear a jobs log without having
to view it directly?

Denzil
by admin
Sat Jan 25, 2003 3:25 am
Forum: Archive of DataStage Users@Oliver.com
Topic: How to Avoid Users from Sign on to Datastage clients during
Replies: 1
Views: 505

Theres no mechanism to stop users from starting DataStage clients, which tend to be on their own PCs. What youre really asking is about preventing those clients from connecting to the server. Stopping the UniRPC server sounds initially like a good approach but doing so would also prevent the export/...
by admin
Fri Jan 24, 2003 5:01 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: column unexpectedly ended by EOR!
Replies: 2
Views: 947

column unexpectedly ended by EOR!

Hi, Running a job which source is sequential file(Ebcdic format) and target is hash file. While running, its giving error message saying CFSCumSpendingSeqToHashed..CFSCumSpendingSeq.FromCFSCumSpendingSeq: read_fixedwidth() - row 309331, column CUR_MOD_BUDGETED_AMT, column unexpectedly ended by EOR a...
by admin
Fri Jan 24, 2003 4:38 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: Oracle greatest/ least function
Replies: 6
Views: 4969

Hi Regu, This isnt a datastage feature, sure!!! The derivation is displayed in red just cause the Minimum and Maximum function in not declared in the DSParams file in the project directory. There is many function that you can use in the transformer but is not declared in that file (Minimum, Maximum,...
by admin
Fri Jan 24, 2003 4:00 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: Metastage reports
Replies: 1
Views: 634

Dear Kamal, The first question is, what information do you want. If all you need is information contained in the source and target table definitions and related links, executable, etc., then your report could easily be based upon a simple Process Analysis. That is, run Process Analysis on a Run or E...
by admin
Fri Jan 24, 2003 3:48 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: Red Expressions (was Oracle greatest/ least function)
Replies: 0
Views: 479

Red Expressions (was Oracle greatest/ least function)

That its red doesnt mean that its invalid. It simply means that the function does not appear in the DSParams file on the server (in the project directory). This is a text file that is used to populate the drop-down list of functions and system variables for the expression editor. You can edit it (th...
by admin
Fri Jan 24, 2003 2:55 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: INTERSOLV (Informix ODBC drivers)
Replies: 0
Views: 1385

INTERSOLV (Informix ODBC drivers)

Hi We have upgrade from DS 5.2 to DS 6.0r3. We are running and Informix database version 7.03 and are using the ODBC drivers. After the upgrade to DS 6, the outer joins do not work anymore. I get the following error: Vetting..SQF_Referals.IDENT1: |Vetting..INT_Referals.oReferals: DSD.BCIOpenR call t...
by admin
Fri Jan 24, 2003 2:36 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: Connecting to MS SQL Server 2000
Replies: 6
Views: 2393

Thanks -----Original Message----- From: Kenneth Bland [mailto:kcbland_2000@yahoo.com] Sent: Friday, January 24, 2003 9:36 AM To: datastage-users@oliver.com Subject: Re: Connecting to MS SQL Server 2000 William, I also had to be case specific as to the configuration parameters, namely ADDRESS and DAT...