Search found 53125 matches

by ray.wurlod
Mon Dec 15, 2003 3:52 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Reading a text file but short of last record
Replies: 6
Views: 2920

You can add the trailing line feed with echo in a before-job subroutine that uses ExecSH or ExecDOS (depending on your OS). Use the >> redirection operator to append.
by ray.wurlod
Mon Dec 15, 2003 3:45 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: schedualling changes using crontab -e
Replies: 2
Views: 1302

That's basically it. If you're confident with the structure of crontab entries, there's nothing to inhibit you. Just make sure that the command line to run the job remains intact!
by ray.wurlod
Mon Dec 15, 2003 3:36 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: max size for varchar in DS
Replies: 3
Views: 1364

There is a limit, but it's primarily influenced by the amount of memory you have. I have seen records in hashed files tens of MB in size. Large records are not efficiently stored in hashed files (needing multiple I/Os to access), but stored they can be.
by ray.wurlod
Mon Dec 15, 2003 3:19 pm
Forum: Data Quality Best Practices
Topic: Operations in Integrity
Replies: 5
Views: 2643

Not sure what you mean by "operations". If you mean "operators", these are the building blocks from which you construct user-written procedures. For example, there is the FFC (file format conversion) operator, the GTF (general transfer function) operator, and quite a few more. You put these together...
by ray.wurlod
Sun Dec 14, 2003 3:38 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: cannot open executable job file
Replies: 23
Views: 6331

I still think it's a corrupted hashed file.
In the project environment, where you executed the LIST statement, can you execute this statement, and let us know the result?

Code: Select all

UVFIXFILE RT_CONFIG1344
This will help further diagnosis.
by ray.wurlod
Sat Dec 13, 2003 2:43 am
Forum: Site/Forum
Topic: Subject
Replies: 0
Views: 1790

Subject

When one replies to a topic, there is a field provided called Subject. On other forums that I use (I really do have a life, too!), anything put in here - for example an amplification of the original subject - gets displayed as part of the reply. Not on DSXChange. Bug? Or intentional, in which case w...
by ray.wurlod
Fri Dec 12, 2003 6:42 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to find size of a Hash File from Datastage Administrator
Replies: 3
Views: 1807

The default (dynamic) hashed file is not a single object in the operating system. It is a directory containing three files, DATA.30, OVER.30 and .Type30. DATA.30 contains only primary groups so its size should be able to be calculated as ((current_modulus + 1) * group_size) - noting, of course, that...
by ray.wurlod
Thu Dec 11, 2003 11:52 pm
Forum: General
Topic: Read JobList from a specified project and category
Replies: 17
Views: 6755

Oh, of COURSE you can!! :P

Code: Select all

PERFORM "SELECT ... FROM ... TO SLIST 5;"
LOOP WHILE READNEXT KEY FROM 5
...
REPEAT
by ray.wurlod
Thu Dec 11, 2003 9:36 am
Forum: Data Quality Best Practices
Topic: different countries in one file... identification using inte
Replies: 5
Views: 2571

Have you tried using the Multinational Address Standardization pre-built procedure? This has a standard output format, two of the columns of which is the country ISO codes (the two character and three character codes). This is NOT the same as the MNS rule set, which you use in SuperSTAN, it's a comp...
by ray.wurlod
Thu Dec 11, 2003 9:16 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Wonderfull SendMail in Sequencial Job
Replies: 5
Views: 1748

Your mail server (the one that does the sending) does not recognize you (the sender client) as a legitimate user of the mail service. It's a mail configuration thing. Get help from whoever configures your mail server. It's almost certain the mail client that dssmtpmail() calls is not Outlook. It's a...
by ray.wurlod
Thu Dec 11, 2003 8:54 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Sequencer triggered few children jobs, ignored the rest
Replies: 5
Views: 1903

Is the job sequence in question job number 121? Check in the Administrator client Command window: SELECT NAME FROM DS_JOBS WHERE JOBNO = '121'; If it isn't, then what you've found in &PH& is unrelated (it's a separate problem that you have!) Do the job activities in the job sequence have triggers fo...
by ray.wurlod
Thu Dec 11, 2003 8:49 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Batch is running !
Replies: 12
Views: 5418

1. Attach job (DSAttachJob) 2. Check that attach succeeded (DSGetJobInfo(hJob, DSJ.JOBNAME)) 3. Check job status (DSGetJobInfo(hJob, DSJ.JOBSTATUS)) 4. If job status indicates that job is worth attempting to reset: (a) detach job (DSDetachJob) (b) attach job (DSAttachJob) -- probably OK not to verif...
by ray.wurlod
Thu Dec 11, 2003 8:40 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: automate CLEAR.FILE &PH&
Replies: 6
Views: 3898

Cynicism 101

May as well post this thought before one of the other cynics does.

Once you start relying on something like this, they'll change it! :x
by ray.wurlod
Thu Dec 11, 2003 8:29 am
Forum: Data Quality Best Practices
Topic: different countries in one file... identification using inte
Replies: 5
Views: 2571

Have you tried using the Multinational Address Standardization pre-built procedure? This has a standard output format, two of the columns of which is the country ISO codes (the two character and three character codes). It handles approximately 200 countries, more than half of the countries in the wo...
by ray.wurlod
Thu Dec 11, 2003 4:06 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: automate CLEAR.FILE &PH&
Replies: 6
Views: 3898

You're in luck! Because you're on a Windows platform. Windows will not allow you to delete a file that's in use - you get a "sharing violation". So if there are jobs running, your CLEAR.FILE &PH& command will generate sharing violation warnings, but things will be safe otherwise.