Search found 2288 matches

by roy
Wed Jan 01, 2014 5:39 am
Forum: General
Topic: How to use Environment Variable in Routine?
Replies: 3
Views: 1771

Why would you want to return the env var? I'm asking because it will ,usually, be available from where you invoked the routine as well. so I would send the values as arguments to the routine and then you can stay with the ordinary implementation of the routine. can you explain more regarding what is...
by roy
Wed Jan 01, 2014 4:06 am
Forum: General
Topic: Transformer stage with 2 main streams going in
Replies: 0
Views: 765

Transformer stage with 2 main streams going in

Hi All, I somehow managed to produce a job with 2 transformers each having the hashed file reference lookup to be a main stream. Can't change to reference or even delete the links I was so surprised that I took a picture of the design. I decided to revert to the backup I saved before making the chan...
by roy
Tue Dec 31, 2013 6:16 am
Forum: General
Topic: Install Updates - Are the files needed after install
Replies: 3
Views: 1199

Ray,
Thanks for the reply!
So there should be no issue if, let's say, they move the folders to D: drive to clear some space in the C: drive.

(Hoping I understood you correctly)

Best Wishes...
by roy
Mon Dec 30, 2013 8:08 am
Forum: General
Topic: DataStage Job Generation using FastTrack mappings
Replies: 3
Views: 1881

Hi,
From memory, no way to check this now.
I think fastrack connects via ODBC
Unless something changed in recent versions
So I think you can't.
Lets see what others think...
by roy
Mon Dec 30, 2013 3:57 am
Forum: General
Topic: Install Updates - Are the files needed after install
Replies: 3
Views: 1199

Install Updates - Are the files needed after install

Hi All, I have an existing install that the sysadmins asked me if they can move some of the update fixpacks from drive C: , since they take up around 3GB the files are under infoshpere\updates and there are log files from the installations. Anyone knows how can I make sure that it is safe to move th...
by roy
Sun Dec 29, 2013 10:48 am
Forum: General
Topic: Datastage--How to track user deleted the parameter set
Replies: 1
Views: 1388

Hi, There are 2 things to say in favour of using a parameter set: 1. it is a repository object that should be part of your backup routine. then you should be able to restore it. 2. you can simply build a new one in its stead and have your development running again in a short time. the above just mak...
by roy
Tue Dec 03, 2013 6:30 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: uploading a value to job parameter
Replies: 5
Views: 3890

Hi, As Craig said, if we think a bit out of the box.... you can have the following logic: sequence: job1 - returning value in user status job2 - getting the returned user status from job1 as parameter This is the usual "work around" for these kind of requests IHTH (I Hope This Helps),
by roy
Mon Nov 04, 2013 8:17 am
Forum: General
Topic: job parameter value
Replies: 3
Views: 1671

Hi, The only way a parameter value is stored in a file, as of today, is if you use parameter sets and set the values to reside inside a file. (in a out of the box feature) In that case it sepends where your file is, you can edit the parameter set on the project at hand and override the file. Another...
by roy
Mon Nov 04, 2013 8:07 am
Forum: General
Topic: Need datastage development efforts advice
Replies: 8
Views: 4320

Hi,
1.This is too complex to answer on 1 foot.
2. You might want to hire a consultant for this, since it will take an effort to estimate.

Good Luck.
by roy
Mon Oct 21, 2013 5:10 am
Forum: General
Topic: IIS 8.7 fixpack2
Replies: 7
Views: 2429

I see no problem installing 100 clients over the weekend or even over 1 night. by means of a distributed silent install.
Talk with your admin guys, they should be able to get you a distributed install which will let you upgrade 100 clients overnight.
IHTH,
by roy
Tue Oct 15, 2013 6:04 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Poor performance - DS Marco in column derivation with Oracle
Replies: 1
Views: 1890

Poor performance - DS Marco in column derivation with Oracle

Hi All, DS 8.5 on windows. I came across an odd situation where I have a transformer link performing an insert to oracle, has verry poor performance, several rows per second. This happens if I use a DS macro such as : DSHostName as the derivation for a column. Work arounds include: 1. using a stage ...
by roy
Tue Sep 24, 2013 4:33 am
Forum: General
Topic: Sequence Jobs - Errors and Questions
Replies: 5
Views: 3355

This means that eithere: 1. A new version of the job was imported , and the required routine for the new version was not imported. 2. Some one deleted the routine from production server (if it was always there with the job using it). 3. Your repository is corrupted; in which case you need to fix it....
by roy
Tue Sep 17, 2013 8:48 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Teradata stage query
Replies: 4
Views: 3084

I just talked to a freind running 8.7 server with Teradata
He says they have multi load plugin stage
perhaps its a parallel job issue only? :roll:
by roy
Tue Sep 17, 2013 8:44 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Teradata stage query
Replies: 4
Views: 3084

Just wondering:
What happens when you take an 8.1 job and upgrade it to 8.7?
does the stage convert to connector?
by roy
Mon Sep 16, 2013 11:08 am
Forum: General
Topic: Sequence Issue
Replies: 4
Views: 2615

Hi, on top of what was said: recap: 1. enable jop property of the sequence job to add checkpoints 2. make sure the job-activities properties do no override this option and negate the checkpoints for each activity You also need to make sure no run in reset mode is being performed on this sequence, si...