Search found 2288 matches

by roy
Mon Dec 10, 2007 8:53 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Insert new or update existing rows in DS 7.5
Replies: 2
Views: 1339

Hi, This usually apears when you run an update query that effects no rows with the givven criteria. So you actually might be getting it the other way around => update existing ten insert new (please check it). So if yu first try to update wit no proper valid index you might be havin your problem. IH...
by roy
Mon Nov 26, 2007 7:24 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Fork Error
Replies: 5
Views: 1949

From the error message you get (and concidering the forum and job type you posted under), you first need to realize your on the enterprise edition (PX) of the product. And it seems that there is an allocation issue with the resources your configuration file specifies and what you actually have. I ha...
by roy
Mon Nov 19, 2007 7:20 am
Forum: General
Topic: Configuring Oracle 9i with Datastage server
Replies: 2
Views: 2005

Hi,
Step one shoould be going over the manual of the Oraoci9.pdf
that should be located under the Docs directory in the client installation directory.
IHTH (I Hope This Helps),
by roy
Wed Nov 14, 2007 4:32 pm
Forum: Site/Forum
Topic: Video Tech Tip Series - FEEDBACK
Replies: 49
Views: 153911

Vincent,
I've just went there and it took several minutes to load and then :idea: :arrow: Ray started talking on my speakers :shock:
Got broadband with 200K or should I say 1.5 MBits download
IHTH,
by roy
Sun Nov 11, 2007 6:51 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DataStage parallel jobs
Replies: 4
Views: 2494

Hi,
What insight have you gained by reading the manual of those stages?
After you do so and explain what you don't understand or what is not working according t wat you understand then we might be able to help further.
by roy
Sun Nov 11, 2007 6:45 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: can you write an ebcdic file with packed decimal with se ds
Replies: 4
Views: 2753

Hi, In the project I'm in right now were using a utility, from HITACHI to move files from windows to a FS that MF sees, that converts the ebcidic part. There for building a routine that builds a comp-3 from a regular ascii based number representation is useless. Instead were using the load to DB2 as...
by roy
Tue Nov 06, 2007 2:29 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to use an Environment Variable into Userdefine routine
Replies: 4
Views: 2390

How about running the job and assigning that environment variable as a parameter to it?
by roy
Sat Oct 27, 2007 2:33 am
Forum: Site/Forum
Topic: Duplicate Posts
Replies: 22
Views: 15216

:idea: Till then you can ask me to remove that duplicate post/s in the same way you ask me to move them from one forum to the other :roll: :wink:
by roy
Thu Oct 25, 2007 10:51 am
Forum: General
Topic: Help how to extract first field in a string (csv file)
Replies: 9
Views: 3461

Re: Help how to extract first field in a string (csv file)

I'm having trouble seeing version 4 with Parallel job type :!: Please update version/job type I have a comma delimite csv file the data looks like "qqxx=ABCDFGFDR123,ddc=0,ss=SS,t=test",getline,cool,testing I want extract ABCDFGFDR123 only. how do I do that? could someone hlep me please. ...
by roy
Thu Oct 25, 2007 10:48 am
Forum: Site/Forum
Topic: Duplicate Posts
Replies: 22
Views: 15216

Automating this might be a problem since some people reply to some posts ad might accidently spread answers between the duplicate posts

You can always notify me via Private Message and I'll take care of it (or pass it along to some one that can for forums I'm not the moderator of)
by roy
Wed Oct 24, 2007 1:06 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Some problem in Sequntial file???
Replies: 6
Views: 2401

Hi,
Can you try closing your designer and openning a new one?
Is it a new client installation that someone forgot installing the XP SP2 patch on?

IHTH,
by roy
Wed Oct 24, 2007 12:59 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: error while extracting data
Replies: 2
Views: 1790

Hi,
Another way would be to read the documentation regarding oracle and send your DBA the part on what privilages you need so it will work

IHTH,
by roy
Wed Oct 24, 2007 12:54 pm
Forum: General
Topic: Cannot install v8.0.1 with repository in SQL Server 2005
Replies: 2
Views: 2145

Hi,
If I'm not mistaken there is a conflict on windows installations with ms sql server (a dll conflict) hence you can't have both on the same machine
At leaset for now

IHTH,
by roy
Tue Oct 23, 2007 12:58 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: FTP Verification Advice
Replies: 3
Views: 1849

Hi,
Using the FTP stage was long ago stated not to be the prefered way to FTP files.
It is recommended to use OS command line for that.

IHTH,
by roy
Tue Oct 23, 2007 12:55 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: how to convert a single row into multiple rows
Replies: 8
Views: 8971

As said before Pivot Stage