Search found 147 matches

by veera24
Wed Jun 18, 2008 9:38 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job Number
Replies: 27
Views: 10650

ag_ram, your list command is incorrect. The syntax of the list command is | SYNTAX | | | | LIST [DICT | USING [DICT] dictname] filename [records | | | FROM n] [selection] [output.limiter] [sort] [output] | | [report.qualifiers] note, the first mandatory parameter is the filename. It just so happens...
by veera24
Wed Jun 18, 2008 9:37 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job Number
Replies: 27
Views: 10650

ag_ram, your list command is incorrect. The syntax of the list command is | SYNTAX | | | | LIST [DICT | USING [DICT] dictname] filename [records | | | FROM n] [selection] [output.limiter] [sort] [output] | | [report.qualifiers] note, the first mandatory parameter is the filename. It just so happens...
by veera24
Wed Jun 18, 2008 9:30 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hashed file
Replies: 7
Views: 1698

ray.wurlod wrote:It is axiomatic that you ought to have no control over physical storage of any individual record; this is a function of the database server so that it can retrieve that record efficiently. Hashed fil ...

hi i couldn see ur information properly. could you pls. help me out.

Thanks...
by veera24
Wed Jun 18, 2008 9:30 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hashed file
Replies: 7
Views: 1698

ArndW wrote:That is a function of many databases. With hashed files the key is "hashed" into a number which corresponds to a hashed file group (or bucket). When the file is read in unsorted order it will read key ...
hi i couldn see ur information properly. could you pls. help me out.
by veera24
Tue Jun 17, 2008 1:25 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hashed file
Replies: 7
Views: 1698

Hashed file

hi all,

Usually when we write data into Hashed file, then the records will be in shuffled manner. Why is it so? Any reason behind that?


Thanks in advance...
veera...
by veera24
Tue Jun 17, 2008 1:19 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: sort
Replies: 6
Views: 2039

sort

hi all,
When I've tried to sort the time field using Sort Stage, it didn't get work out. So that I've converted the time field value using iconv function. Is there any direct way of sorting then pls. let me know.

Your time will be highly appreciated...

Thanks in advance...
veera...
by veera24
Tue Jun 17, 2008 1:09 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job Number
Replies: 27
Views: 10650

ArndW wrote:I just realized that this thread is in the Server forum and the solution with the job number that I posted was for Parallel jobs; so you are quite correct that it was the wrong answer.

You can get ...
its k... then where shall i get the job number then?
by veera24
Mon Jun 16, 2008 10:08 pm
Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
Topic: Sort
Replies: 1
Views: 2571

Sort

hi all,
When I've tried to sort the time field using Sort Stage, it didn't get work out. So that I've converted the time field value using iconv function. Is there any direct way of sorting then pls. let me know.

Your time will be highly appreciated...

Thanks in advance...
veera...
by veera24
Mon Jun 16, 2008 10:04 pm
Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
Topic: Hashed file
Replies: 1
Views: 2598

Hashed file

hi all,

Usually when we write data into Hashed file, then the records will be in shuffled manner. Why is it so? Any reason behind that?



Thanks in advance...
veera...
by veera24
Mon Jun 16, 2008 9:57 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job Number
Replies: 27
Views: 10650

chulett wrote:Lovely.
ArndW wrote:veera24 - I neglected to finished the details in my original post. Open up the 3rd log entry, where the ENVironment is displayed, and the LD_LIBRARY_PATH will have the jobno ...
hi i didn see any number there... could you pls. clarify...
by veera24
Mon Jun 16, 2008 9:56 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job Number
Replies: 27
Views: 10650

chulett wrote:Lovely.
ArndW wrote:veera24 - I neglected to finished the details in my original post. Open up the 3rd log entry, where the ENVironment is displayed, and the LD_LIBRARY_PATH will have the jobno ...
hi i didn see any number there... could you pls. clarify...
by veera24
Sun Jun 15, 2008 10:02 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: OBJ files
Replies: 4
Views: 1468

OBJ files

hi cud any one tell me about OBJ files?
by veera24
Sun Jun 15, 2008 10:00 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job Number
Replies: 27
Views: 10650

Job Number

hi all,
Could any one tell me that where shall i get the job number of a particular job when it runs successfully?


Your time ll be appreciated..

Thanks in advance
veera...
by veera24
Wed Jun 04, 2008 10:04 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Phantom error
Replies: 2
Views: 938

Phantom error

hi all
Could any one pls. explain what is mean by phantom error? Why it is being occurred? I've searched the forum but i got the information regarding identification of Phantom error only...

Thanks in advance....
by veera24
Wed Jun 04, 2008 9:59 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Regarding number of months
Replies: 1
Views: 743

Regarding number of months

hi all, Am having two i/p columns which consists of date field. Am in need to take the difference between these two columns and i got to change into number of months. Is there any function to implement the same? Or shall i take the difference between the two by using iconv function and then divide ...