Search found 42189 matches

by chulett
Mon Nov 09, 2009 6:19 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: The server is not responding
Replies: 12
Views: 5385

For 'sudo' just ask them, if you need to explain to them how to do it, it's time to find a new SysAdmin. They should just need the user and what to grant it on, as noted.
by chulett
Sun Nov 08, 2009 8:27 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to check byte length of data?
Replies: 10
Views: 4457

How to check byte length of data?

Got the dreaded 'ORA-12899 value too large for column' error because somehow a two character field got some multi-byte crappola in it and it won't fit in an Oracle VARCHAR2 field defined as 2 bytes rather than characters. :evil: Is there an expedient way to check the byte length of a string? May nee...
by chulett
Sun Nov 08, 2009 8:17 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DataStage with HP Neo
Replies: 6
Views: 1569

Apparently there is. While an "HP Neo" is a laptop, "HP Neoview" is a BI platform, a combination of hardware and software much like Teradata it seems. ODBC and JDBC seem to be the weapons of choice.
by chulett
Sun Nov 08, 2009 5:42 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DataStage with HP Neo
Replies: 6
Views: 1569

It's really just another Vista laptop, although in the 'ultraportable' camp. Does 'load data in' mean 'install the server on'? Me, I wouldn't consider it on such a low-end single core system. :?
by chulett
Sun Nov 08, 2009 1:21 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: The server is not responding
Replies: 12
Views: 5385

Have them grant you (dsadm) 'sudo' privileges for the startup scripts.
by chulett
Sat Nov 07, 2009 11:15 pm
Forum: General
Topic: Job Sequences
Replies: 3
Views: 1100

Hence the suggestion to run a smaller number at a time. :wink:
by chulett
Sat Nov 07, 2009 12:25 pm
Forum: General
Topic: Job Sequences
Replies: 3
Views: 1100

Use Sequencers set to All to run "groups" of jobs at the same time. Say, 10 jobs per so those 10 all link to a Sequencer and from there to 10 more jobs. Lather, rinse, repeat.
by chulett
Sat Nov 07, 2009 11:16 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Compilation error while using transformer
Replies: 5
Views: 1707

Seemed pretty obvious to me. Your compiler is complaining about the "-W/EHa" option you are using so you'd need to "fix" that. I don't use VS so no clue what it means and don't know if you should remove it or what.
by chulett
Sat Nov 07, 2009 11:10 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Sequence no column in transform stage
Replies: 4
Views: 1236

Yes. Sorta. Check the ellipsis (...) in the editor for System Variables and you'll find there are two of them: @INROWNUM and @OUTROWNUM and it's important to understand the difference between them.
by chulett
Sat Nov 07, 2009 10:30 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Sequence no column in transform stage
Replies: 4
Views: 1236

Depends on what you need it for and what it needs to start from. Simplest way is the @IN/OUTROWNUM system variables. There's also the KeyMgmt routines in the sdk branch. The former starts at 1 but can be given an offset that you increment by them, the latter keeps track per 'object' tracked and each...
by chulett
Sat Nov 07, 2009 10:23 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Difference between validation and run
Replies: 1
Views: 1161

Validate doesn't run, for one. It's fully explained in the documentation - specifically the Director Client Guide pdf from the Bookshelf.
by chulett
Sat Nov 07, 2009 9:41 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Compilation error while using transformer
Replies: 5
Views: 1707

Re: Compilation error while using transformer

jaysheel wrote:##E TFCP 000209 20:36:28(000) <transform> Unrecognized argument: -W/EHa
...
APT_COMPILEOPT : -W/TP -W/EHa -DAPT_USE_ANSI_IOSTREAMS -c
Hmmm...
by chulett
Sat Nov 07, 2009 8:40 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Concatenation of multiple row string values to one column
Replies: 4
Views: 2559

And you would be whom? First post at the end of someone else's months later doesn't help things much.

:!: Start your own post in the appropriate forum. Include the details of what you need to do there (not here). Then people will be able to help.
by chulett
Sat Nov 07, 2009 8:33 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Whitespace added after every value
Replies: 14
Views: 3303

Re: Whitespace added after every value

pandujoy wrote:I have the $APT_STRING_PADCHAR to 0x20 .
by chulett
Fri Nov 06, 2009 7:05 pm
Forum: General
Topic: YADSSM (Yet another DS SendMail) question
Replies: 7
Views: 8309

Then have your script check the file (perhaps using "test -s") and conditionally send the email if the file is non-empty.