Search found 2288 matches

by roy
Mon May 23, 2005 8:17 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Controller problem:
Replies: 2
Views: 1098

Hi, "Given up waiting for something to happen" is not really far from what was reported in the original post. So the question is or should be what does that job do? Are you using any pack enhancement? (Like SAP?!) Are you running something that hung or exceeded some time-out? Can you give more detai...
by roy
Mon May 23, 2005 5:24 am
Forum: IBM QualityStage
Topic: Does QS provides NLS support
Replies: 2
Views: 1653

Hi, Sorry for the late answer . We tested a while back some hebrew with QS and it seemed to work. as for the phonetic and speelling look alikes obviously you need to check How well or if the existing functions work and what does it mean if you have your own or 3rd party utilities instead that you wa...
by roy
Mon May 23, 2005 4:23 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Too many quotes?
Replies: 10
Views: 2428

Hi, I'm rather disapointed by your statement It's like saying you expect i.e. wondows media player to show you movies in a format it does not know how to handle?! The big Difference is that DS enables you to create a characters set that supports none standard characters (which are by the way support...
by roy
Mon May 23, 2005 2:40 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Stage which will validate xml schema
Replies: 1
Views: 567

Hi,
Last time I checked we had 3 XML stages:
1. XML_Input
2. XML_Transformer.
3. XML_Output.

I also recall 1 of them (at least) had a validation option in it.

IHTH,
by roy
Mon May 23, 2005 2:35 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: MS SQL Server Bulk Insert configuration
Replies: 1
Views: 767

Hi, As said before (search this forum for complete coverage) best performance will be using native bulk load. is your SQLServer on the same machine as your DS Server? if so try invoking it via command line or user defined SQL. Tweeking SQLServer parameters is a question for your DBAs. I would storng...
by roy
Mon May 23, 2005 2:19 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job Export Command
Replies: 7
Views: 1832

Hi,
I think the only other way would be to implement the DS API (i.e. in VB).
It will still remain a client side action.

IHTH,
by roy
Sun May 22, 2005 12:39 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Null handling
Replies: 4
Views: 1167

Hi, I can understand the . posting in the EE forum asking of PX and Server routines and posting server in the job type. Are you using a mix of server and PX jobs and experiancing differences in behaviour? You might want to make the situation and the question more clear so people might answer a worth...
by roy
Thu May 19, 2005 6:52 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Extract Numberics & Chars only from a string
Replies: 8
Views: 1768

Hi, For some strange reason I can't help feeling like the problem might be something like reading a windows source file that still has CRLF line termination instead of LF only as in unix. if that is the case you can use the CRLF style on the sequential file or make sure when it is transfered to you ...
by roy
Thu May 19, 2005 4:44 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Too many quotes?
Replies: 10
Views: 2428

Hi,
using a 000 for a qoute string will eliminate any " from wrapping your character based data types.
3 zeros actually represent the fact there is no qoute string.

It is documented (at least in the course materials).

IHTH,
by roy
Thu May 19, 2005 4:25 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: size of longnvarchar datatype (Datastage SQL Datatype)
Replies: 2
Views: 3323

Hi, I never seen a folder stage passing a bigger file then several hunderds of MB. It is configurable or system dependant (I don't know how ) I assume since different machines had different thresh-holds. Test the folder stage with large file to see your limit. I'd recommend trying to use URLs, if yo...
by roy
Thu May 19, 2005 4:19 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DataStage System Logs
Replies: 2
Views: 1908

Hi,
To add on what was said
Most times connection problems are related to fire-walls killing them or network issues.

IHTH,
by roy
Thu May 19, 2005 12:51 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to generate a calendar Year Using DataStage
Replies: 12
Views: 7451

Hi, one way would be to calculate the end date depending on the start date and just run a job that gets the dates and builds the data. this job will naturally start with a transformer generating the rows. If you need the full process reply and ask for it (I'll give it more attention when I can). or ...
by roy
Thu May 19, 2005 12:33 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Client-side backups using " dscmdexport"
Replies: 15
Views: 3231

1 more thing,
though the gzip is disabled I enabled it and in fact am zipping my dsx files.
note that I did download a gzip utility since winzip insists on poping an interactive window even in certified version.
by roy
Thu May 19, 2005 12:28 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Teradata Stored Procedure
Replies: 4
Views: 1272

Hi, 2 options: 1. implement the mechanism via DS rather then SP. 2. Call your procedure and get the info (perhaps using a user defined sql). option 1 depend on the restriction of: can you, buisiness wise, use this option. the solution in option 2 varies depending on the input/output and specific log...
by roy
Thu May 19, 2005 12:19 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Node dies issue
Replies: 2
Views: 1359

Hi, what exactly are you asking? Did you verify the issues in the message are hapenning? If your problem is as mentioned (configuration and mount problems) there is not much any of us can do about it. Except maybe to sugest you build a script that verifies resources and builds the apt config file dy...