Search found 42189 matches

by chulett
Wed Nov 24, 2010 7:05 am
Forum: General
Topic: DataStage Sequencers not calling the jobs sometimes.
Replies: 4
Views: 2381

Re: DataStage Sequencers not calling the jobs sometimes.

Calling, yes. Able to run? No.
prasanna_anbu wrote:not a run-able job.
/tmp is full.
by chulett
Wed Nov 24, 2010 7:03 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: GET FILENAME
Replies: 37
Views: 9673

This all seems... overly complicated to me. A simple script or Execute Command in a Sequence could get the 'latest' filename from the directory and then pass it as a parameter to your processing job. :?
by chulett
Wed Nov 24, 2010 7:00 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Records missing in the sequential file
Replies: 3
Views: 1345

No, you reposted it, I on the other hand would have moved it for you. Being a Moderator and all. However, I do have this silly habit of sleeping for a couple of hours at night. :wink:
by chulett
Wed Nov 24, 2010 6:58 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Records missing in the sequential file
Replies: 15
Views: 6954

Note that the Server job used hashed files for the target, not sequential files, a detail that makes all of the difference in the world. The former is a database table, the latter... not so much. As Arnd noted, sequential media does not support multiple writer processes, regardless of the tool used....
by chulett
Wed Nov 24, 2010 6:45 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Count Of records
Replies: 12
Views: 3093

'Count of records passing on that link'? That would always be 1 unless you are doing aggregation based on the two fields... are you? :? If so, then an inline Aggregator can do the grouping and counting for you. If you need to do something else, then please be more specific in your problem description.
by chulett
Wed Nov 24, 2010 6:39 am
Forum: General
Topic: Regarding Install of server and client components in 8.1
Replies: 1
Views: 921

Re: Regarding Install of server and client components in 8.1

kirankumarreddydesireddy wrote:Do I need to install separately from client_IA-suite to get the components of like Designer,Director,Manager?
Yes.
by chulett
Tue Nov 23, 2010 10:32 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: how to fetch the columns having multiple fields in a text fi
Replies: 3
Views: 1257

Not sure why it would take one and not the other. Is your second field's size large enough to hold the entire string?
by chulett
Tue Nov 23, 2010 10:07 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Warning in Hash file
Replies: 2
Views: 1208

So... this error happened one time and then after that it has been fine, or it comes every other time - doesn't work, works, doesn't work, works? :?
by chulett
Tue Nov 23, 2010 9:27 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: how to read BODY data by using sequential file
Replies: 3
Views: 1585

Could you not also declare the three columns and then only pass records where the second (and thus third) columns are populated?
by chulett
Tue Nov 23, 2010 7:36 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: null_field length (0) must match field's fixed width (14)
Replies: 8
Views: 10166

That is neither a timestamp nor 14 characters. :?
by chulett
Tue Nov 23, 2010 7:15 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Reading Multiple record types in a file using CFF stage
Replies: 4
Views: 2462

You could also engage your official support provider for help with this procedure that plays a key role in your project.
by chulett
Tue Nov 23, 2010 7:12 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sftp ing the files and deleting files on remote server.
Replies: 17
Views: 11644

The stage has both telnet before and after options, from what I recall. They can be used for tasks such as this, although the fact that this is a secure connection may change that. :?
by chulett
Tue Nov 23, 2010 7:07 am
Forum: General
Topic: Backup Automation
Replies: 3
Views: 1573

I'm also going to note, although this has been covered extensively which a search will reveal, there is no "folder wise" export. For automation, it would typically be entire projects. Your other choice is single jobs.
by chulett
Tue Nov 23, 2010 7:04 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How can I read a column of data type is IMAGE
Replies: 0
Views: 3267

Well... first thought? Set the array size to 1.
by chulett
Tue Nov 23, 2010 7:03 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Complex flat file reading
Replies: 5
Views: 1791

So... this is resolved? :?