Search found 2288 matches

by roy
Mon Feb 10, 2014 7:35 am
Forum: Site/Forum
Topic: Where Would you like to see special topics
Replies: 3
Views: 8344

guess its fine as is and no real interest to our audiance.
closing it
by roy
Mon Feb 10, 2014 7:33 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Migration to 9.1 and CRC32 function
Replies: 9
Views: 6132

I've came across several cases of CRC32 and the likes of it, of any form and provider, returning same output for different inputs !!!
There for I never use them as detecting changes or serogate keys.
by roy
Mon Feb 10, 2014 6:12 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: wierd Iconv expresion
Replies: 1
Views: 2279

wierd Iconv expresion

Hi All,
seen this expresion in a job:

Code: Select all

iconv(myDate,"DYMD" : @VM : "MCN")
it does return the same as:

Code: Select all

Iconv(myDate,"DYMD")
I was wondering was there something I missedd regarding Iconv
or is it simply a missused syntax (that accidentaly works) ?

Thanks,
by roy
Mon Feb 10, 2014 6:08 am
Forum: General
Topic: Using ODBC connection via DS Basic
Replies: 6
Views: 2644

ray.wurlod wrote:The UNIVERSE.INCLUDE location has been available since version 1.0.
Not saying it wasn't.
A few (maybe more) versions back there was also an odbc.h under the include main directory.
Now I seen its a miss from that location
by roy
Tue Jan 28, 2014 6:19 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Unable to open file status=13
Replies: 4
Views: 3571

Unable to open file status=13

Hi All, I'm experiencing a weird behavior: If I have a job that writes to a sequential file and upon completion reads from that same file in the same job it fails saying: unable to open file <fname> status=13 all in 1 job: DB > Xfm > SF > Xfm > DB This fails 2 separate jobs: job1: DB > Xfm > SF job2...
by roy
Tue Jan 21, 2014 9:58 am
Forum: Site/Forum
Topic: Where Would you like to see special topics
Replies: 3
Views: 8344

Indeed Craig,
I'm simply trying to hear what the members prefer :)
Since not everyone can post there.
And yes I remember we have the dicussion forum.
by roy
Tue Jan 21, 2014 6:58 am
Forum: Site/Forum
Topic: Where Would you like to see special topics
Replies: 3
Views: 8344

Where Would you like to see special topics

Hi, Would you like to see special topics covered as Faq forum posts or as Sticky post in the relevant Foum? The idea is to gather Special Topics (ie: Backup, Clear logs,...) and to put the under the FAQ forum or as sticky posts in the forum the belong to. Any ideas regarding this, may be posted in r...
by roy
Mon Jan 13, 2014 10:50 am
Forum: General
Topic: Export: Export job executables without design
Replies: 1
Views: 1626

IMHO, (In My Humble Opinion) The only reason to export without design is to hide your implementation. This means the project that imports the jobs will have no design, hence no way to maintain the jobs. Furthere more what will you do, if the job fails? you have no design to debug or fix in case it f...
by roy
Mon Jan 13, 2014 10:42 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: remove string Dynamically
Replies: 3
Views: 2574

Hi, As craig said your example seems to have a changing algorithym 0000000002 000000000 ~0000000009~1001~ ~VENDOR~0000000138~1001~ ~VENDOR~0020009816~2001~ ~0020009816~2100~ in the above example you supplied there are several different logics for extracting the data rows 1+2 first and only field row...
by roy
Sun Jan 12, 2014 10:37 am
Forum: Site/Forum
Topic: Mark As Unread
Replies: 4
Views: 8586

I third the motion :)

I guess its more of an issue to the ones of us that unswer/moderate
than to other users :roll:
by roy
Sun Jan 12, 2014 10:11 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Multiple Inputs to one CSV
Replies: 4
Views: 3477

Hi, If I understood correctly, you have severl source files that need to eventually be written to a single sequential files with the CSV format. So there are several solutions available, depending on the similarity or lack of, between your source files. Writing to a sequential files simultaniously f...
by roy
Sun Jan 12, 2014 9:35 am
Forum: General
Topic: Drop wasadmin - Problems with WAS & Datastage authentica
Replies: 3
Views: 2387

Hi,
Please contact your support provider for a formal answer.

You might need to clean install the product all over.

Also consult your sysadmin regarding this issue as for the user administration perspective.

Good Luck,
by roy
Wed Jan 08, 2014 6:08 am
Forum: General
Topic: Using ODBC connection via DS Basic
Replies: 6
Views: 2644

Thanks Ray,
So that is the new/correct location now a days?

I do recall it being under ther dsinclude few versions back.

Cheers,
by roy
Tue Jan 07, 2014 8:12 am
Forum: General
Topic: Using ODBC connection via DS Basic
Replies: 6
Views: 2644

Using ODBC connection via DS Basic

Hi all, in previous versions there was an ODBC header file in the dsinclude folder under each project. I now notice on a 8.5 installation that this file is no longer there. does that mean that we can no longer use a Basic routine/job control to use the DS Basic language to connect and utilize the od...
by roy
Tue Jan 07, 2014 8:08 am
Forum: General
Topic: To get the status of Jobs
Replies: 9
Views: 6941

Just wondering...

This is posted as a parallel job question.
Will it work the same?

How do you set/get the user status for the parallel jobs?