Search found 42189 matches

by chulett
Fri Jun 30, 2006 10:16 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Creating a left buffer on a column
Replies: 14
Views: 3001

From memory, more like:

Code: Select all

FMT(DSLink3.CURNT_BAL_AMT,"17'0'R2")

To ask it to move the decimal point over two places...
by chulett
Fri Jun 30, 2006 9:58 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Creating a left buffer on a column
Replies: 14
Views: 3001

While the DIGITS transform will remove the 'dot' there is an official way to do that using the FMT command all at the same time. Check into the 'descaling' option.
by chulett
Fri Jun 30, 2006 7:24 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: export PATH, LD_LIBRARY_PATH
Replies: 1
Views: 743

A quick Google turned up this interesting commentary on LD_LIBRARY_PATH that may help.

Basically, one sets up the search path for executables while the other sets up the seach path for shared libraries.
by chulett
Fri Jun 30, 2006 6:53 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DataStage handler problem
Replies: 5
Views: 2864

Jobs run the same way when started in the Designer, the Director and the command line, so that wouldn't have caused your problem. Not quite true. The difference? Jobs run from the Designer default to allowing unlimited warnings, which fools many people into thinking their job 'ran fine' because the...
by chulett
Fri Jun 30, 2006 6:49 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DataStage handler problem
Replies: 5
Views: 2864

It's obviously a message from a Sequence job with the 'Automatically handle activities that fail' enabled. MappsMDI205ProjectsExtractJob is a job it was running that aborted and the Sequence decided to handle. You need to dig into the log of the job that failed to find out why... what you posted isn...
by chulett
Fri Jun 30, 2006 6:40 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: XML input and output
Replies: 1
Views: 923

Re: XML input and output

Has anyone faced this issue that new line in input XML is considered as data? So this is the question, eh? Short answer is 'yes'. Somewhat longer answer I was given by my resident gurus was it depends on the parser. They also did not like the so-called 'format' of the formatted output. And I didn't...
by chulett
Thu Jun 29, 2006 11:37 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: To check the output file rowcount
Replies: 10
Views: 2409

Post your routine code. Plus I'd suggest you think about doing this 'post job' as in a Sequence job or possibly after job. It depends on exactly what you mean by 'display an error' if the processed row count is zero.
by chulett
Thu Jun 29, 2006 9:35 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Connection Error
Replies: 24
Views: 8052

FYI - fixtool doesn't think anything is wrong with UV_USERS, even at level 10. :?

Question - if I can get ahold of an SA tomorrow to walk them through the FIX option, do I absolutely need to get all DS users disconnected first?
by chulett
Thu Jun 29, 2006 8:59 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Connection Error
Replies: 24
Views: 8052

Yah, same here. However, since this is 'only a development server' I won't be able to get my virtual hands on one until tomorrow during 'working hours'. :roll:

Thanks.
by chulett
Thu Jun 29, 2006 8:51 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Connection Error
Replies: 24
Views: 8052

I'll give fixtool a shot and let you know what happens. And what comes of any transplants of the hashed file from another server. :wink:
by chulett
Thu Jun 29, 2006 8:30 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Connection Error
Replies: 24
Views: 8052

Interesting... in spite of the fact that 'dsadm' is the administration user and has 'DBAUTH' privledges, I can't "FIX" UV_USERS. First thing it says when I try is: User does not have superuser privledges! Disabling the FIX option and continuing. What, I have to be root? That's not gonna happen...
by chulett
Thu Jun 29, 2006 8:10 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Connection Error
Replies: 24
Views: 8052

Thanks. 1) Both DATA.30 and OVER.30 are 4096 bytes with dates from 2005. 2) No, I get the same 'read operation failure' as noted before. 3) First it lists the filename, then 'File has 4 groups' and then lastly a similar 'read operation failed' and 'Internal data error'. Doesn't seem like a repair wi...
by chulett
Thu Jun 29, 2006 6:42 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Connection Error
Replies: 24
Views: 8052

You'd have to tell me if this means it is repairable or not... I'm assuming it is but will wait until our scheduled maintenance window tonight (or a reply back) to find out. >UVFIXFILE UV_USERS File modulus is greater than physical file. Invalid nextsplit ptr in header. Beginning TRACE of sql/catalo...
by chulett
Thu Jun 29, 2006 4:14 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Connection Error
Replies: 24
Views: 8052

You had an extra 'A' - it's DBAUTH. And here's what happens when I run that: >SELECT * FROM UV_USERS WHERE DBAUTH = 'YES'; User Name.......... dsadm DBauth Privilege... YES Resource Privilege. YES Author............. dsadm Own-Table Schema.. Owned Tables...... CATALOG UV_TABLES CATALOG UV_COLUMNS CA...
by chulett
Thu Jun 29, 2006 2:35 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: eMail attached file if record count is greater than zero
Replies: 7
Views: 2132

Or just conditionally link to the Notification Activity stage from there based on the routine's return code.