Search found 53125 matches

by ray.wurlod
Thu Dec 02, 2010 6:12 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: string to timestamp error
Replies: 12
Views: 24058

You have a colon between seconds and fractional seconds in your data, but your format string specifies a dot. You need to make them match by changing one or the other.
by ray.wurlod
Thu Dec 02, 2010 6:10 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Row Count using Stage Variable
Replies: 9
Views: 8117

I guessed that was only because the server platform is Windows, but MKS Toolkit (which installs with Information Server on the engine tier) gives access to such commands.
by ray.wurlod
Thu Dec 02, 2010 1:42 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Row Count using Stage Variable
Replies: 9
Views: 8117

How about using wc -l filename as a filter command?
by ray.wurlod
Thu Dec 02, 2010 1:37 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Reading a file using sequential file stage
Replies: 7
Views: 3361

Re: Reading a file using sequential file stage

Hi, Read ur file with a delimiter that u think will not come in ur file as a delimiter,this will read record in ur file as a single column. If you want to create the different files of same delimiter we can do that also using a transformer and count function in the constraint. Regards Sachin Gupta ...
by ray.wurlod
Thu Dec 02, 2010 1:32 pm
Forum: General
Topic: DataStage Sequencers not calling the jobs sometimes.
Replies: 4
Views: 2381

Not possible without the sequence log and without understanding the logic (triggers, for example) in your sequence. Use the "logging text" entries in activities to add tracing information into the sequence log.
by ray.wurlod
Thu Dec 02, 2010 1:31 pm
Forum: General
Topic: How to find the jobs in Unix level
Replies: 9
Views: 3229

can you tell me in detail where i am missing that can u tell me abt dsenv file and how to configure it Please strive for a professional standard of written English on DSXchange. This will assist those whose first language is not English. DSXchange is not a mobile telephone - there is neither reason...
by ray.wurlod
Thu Dec 02, 2010 1:28 pm
Forum: General
Topic: Reg:Oracle as MetadataRepository for Infosphere 8.1 install
Replies: 7
Views: 1746

No. If ever you bring down the metadata repository, this is done LAST, after the engine, the node agents and the WebSphere application server.
by ray.wurlod
Thu Dec 02, 2010 1:25 pm
Forum: IBM QualityStage
Topic: how long for a simple duplicate project?
Replies: 2
Views: 1853

Why not just get yourself a premium membership? It's not expensive - less than 30c per day, and the revenue helps to keep DSXchange operating.

Because premium memberships keep DSXchange alive, I'd like to discourage anyone from undermining that mechanism.
by ray.wurlod
Thu Dec 02, 2010 4:59 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to increment the value in Database while updating table
Replies: 3
Views: 1848

Welcome aboard. This kind of problem is usually solved with stage variables, whose derivation expressions can include If..Then..Else logic and which can be given initial values. For example svNoOfTries might be derived as If svNewEmployee Then 1 Else svNoOfTries + 1 Of course, I do not know your bus...
by ray.wurlod
Thu Dec 02, 2010 4:57 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: need to load date time from file to table
Replies: 12
Views: 4732

Just load it, providing a suitable Oracle date picture.
by ray.wurlod
Thu Dec 02, 2010 4:55 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: TOAD vs DataStage
Replies: 18
Views: 10728

Because you - YOU - are setting your array sizes ridiculously high. The "sweet spot" is usually low thousands, even just hundreds, depending on your row sizes.
by ray.wurlod
Thu Dec 02, 2010 4:52 am
Forum: General
Topic: Reg:Oracle as MetadataRepository for Infosphere 8.1 install
Replies: 7
Views: 1746

You can install only Oracle client on the engine tier for Information Server. Note that there are special considerations if you want to use an Oracle RAC for your repository. The correct order for shutdown is engine tier, services tier, repository tier (the last being your Oracle database). It is ra...
by ray.wurlod
Thu Dec 02, 2010 4:51 am
Forum: General
Topic: Is there any way to send one more recipients?
Replies: 2
Views: 1630

Try separating with space characters. Ultimately the separator character is whatever your SMTP client and mail server require.
by ray.wurlod
Thu Dec 02, 2010 4:50 am
Forum: General
Topic: Regarding installation of Infosphere 8.1 server edition
Replies: 8
Views: 3619

You can install only Oracle client on the engine tier for Information Server. Note that there are special considerations if you want to use an Oracle RAC for your repository. The correct order for shutdown is engine tier, services tier, repository tier (the last being your Oracle database). It is ra...
by ray.wurlod
Thu Dec 02, 2010 4:46 am
Forum: IBM QualityStage
Topic: how long for a simple duplicate project?
Replies: 2
Views: 1853

The rules (in your case probably ESNAME) come out of the box. Most of the time will be taken up in consultation with the business and with the process of design. You probably need to spend some discovery time profiling the data, in particularly word investigations to identify unhandled patterns, so ...