Search found 20 matches

by Abhijeet
Fri Sep 08, 2006 4:15 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: string to decimal
Replies: 5
Views: 2915

string to decimal

Hi ,

what would be the expected output if i try to read a string say "1024" using datatype decimal[4,2] in a sequential file ?

also what will be the output if the string is 10.

Please reply , I dont have an environment to check these things. :)

Thanks
by Abhijeet
Fri Aug 04, 2006 3:39 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Creating shared libraries for buildops
Replies: 3
Views: 2207

Hi guys, I have worked on such a thing ... creating SO libraries for buildops , because we didn't wanted to recompile the job. I am sending u a link .. this has it all , how to create the SO libs and how to call them ... http://www.faqs.org/docs/Linux-HOWTO/Program-Library-HOWTO.html Have fun :D ~Abhi
by Abhijeet
Tue Jul 25, 2006 11:20 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Can we achieve version control in DSPX
Replies: 11
Views: 4837

Yes i'm talking about keeping track of various versions of the jobs .

Ab initio has an "eme server" which does the same {thats what i have read} , so i was wondering does DSPX has any such thing .

btw ashwin what does datastage version controller does ??
by Abhijeet
Tue Jul 25, 2006 3:45 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Backup and recovery on failure
Replies: 3
Views: 2138

Backup and recovery on failure

Hi ,

will any one put light on backup and recovery on failure of jobs or projects in DSPX.

Thanks
by Abhijeet
Thu Jun 01, 2006 11:44 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Diffrence between two record level options
Replies: 1
Views: 1039

Diffrence between two record level options

hi ,

Is there any difference between

final_delimiter=end

&

final_delimiter=none
record delimter string =\n

logical they are same , right ???
by Abhijeet
Wed May 31, 2006 11:36 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Reading multiple input files using external source stage
Replies: 4
Views: 2286

File set cannot read file names from a sequential file

Do you mean creating a .fs file{which will need some scripting} and then read the file using fileset stage ?
by Abhijeet
Wed May 31, 2006 9:52 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Reading multiple input files using external source stage
Replies: 4
Views: 2286

Reading multiple input files using external source stage

Hi, I have to read N input files all with the same schema.Their complete path along with the filenames are stored in file A . Now i have to concatenate all these files to create one input file. Right now I have a job which reads the file A from a external source stage using the unix command "ca...
by Abhijeet
Fri May 12, 2006 12:23 am
Forum: IBM QualityStage
Topic: FAQ set for QualityStage
Replies: 1
Views: 2309

FAQ set for QualityStage

Hi,


I am in a need of FAQs for QS 7x. Any pointers will be useful. Thanks in advanced.

~AJ
by Abhijeet
Wed Apr 26, 2006 11:32 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Log files for datastage
Replies: 1
Views: 1198

Log files for datastage

Hi,

I wanna know does DSPX maintains a log about the changes done in its repository . EG: if i wanna know when was a job deleted from the repository , is there a log file with each entry .

Thanks.
by Abhijeet
Wed Mar 01, 2006 9:35 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: packed decimal value, how to supress zeros
Replies: 5
Views: 3980

Thanks Ray Still I am not able find the solution. Wondering if I need edit properties for the perticular column (decimal one).. Regards, Gaurav you need to do two things . 1> remove the "." from the string when writing it to the file. 2> by default "all zeroes" is not considered...
by Abhijeet
Mon Feb 27, 2006 10:43 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Pattern matching in parallel
Replies: 2
Views: 1653

thanks ray !!! External Filter Stage is perfect for me !!!
by Abhijeet
Mon Feb 27, 2006 12:59 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Pattern matching in parallel
Replies: 2
Views: 1653

Pattern matching in parallel

How can I do a pattern match say "B[0-9]G[0-9]" in datastage ?

eg:
Description Field --> "Sale: B1G2 free"
"Sale: B2G3 free"


Thanks
Abhijeet
by Abhijeet
Mon Dec 26, 2005 11:26 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to read the numeric part of a string in PX
Replies: 8
Views: 2947

True, lets stick to extracting all numeric characters from a string . :)
So is it possible in PX without me writing any routines ?