Search found 548 matches

by Krazykoolrohit
Tue Jun 17, 2008 1:46 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ORA-01017: invalid username/password: Logon denied
Replies: 5
Views: 5820

Check if the DSN name you are using actually points to the Database you want to run your SQLS from.
by Krazykoolrohit
Tue Jun 17, 2008 1:44 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Reading file with multiple header and trailer
Replies: 1
Views: 1736

Re: Reading file with multiple header and trailer

Header1 Det Records1 (Width 80) Trailer1 Header2 Det Records2 (Width 80) Trailer2 Header3 Det Records3 (Width 80) Trailer3 Read each line as one record into a column1 defined as varchar 200. Use a tranformer to sort the rows out into various links. you can build the logic inside transfomer that say...
by Krazykoolrohit
Tue Jun 17, 2008 1:38 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Regarding EnvVariable
Replies: 5
Views: 2858

Re: Regarding EnvVariable

das_nirmalya wrote: 1;$<env_var>/
Is this what you are writing in after-job subroutine? or is it a part of the command?

What does the above do?
by Krazykoolrohit
Tue Jun 17, 2008 1:35 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: fixed length file format/mapping
Replies: 2
Views: 2224

If I follow the lenths in transformer, see lengths then it is wrong.
what does this mean?
by Krazykoolrohit
Mon Jun 16, 2008 12:55 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to check the white spaces in a field of Char 40 Bytes
Replies: 1
Views: 1904

try the following:

If left(AREA2,2) = ' '
then ('AB':right(AREA2,len(AREA2)-2) )
Else AREA2
by Krazykoolrohit
Mon Jun 16, 2008 10:42 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: aggregator sort method issue
Replies: 19
Views: 21302

Are you sorting the data on those 12 columns before feeding into aggregator?

from what i know, a sort option in aggregator assumes that the input data will be sorted on those columns.
by Krazykoolrohit
Wed Jun 11, 2008 3:02 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Reading Fixed length record file
Replies: 9
Views: 6542

Re: How to read fixed width from a schema file

I want to know if we can read a fixed widht file using the schema file ..........my problem is i get data from different locations and the schema for each of them is different.......i want to read data from any source just by changing the schema file ....i could do that for a comma delimited file ....
by Krazykoolrohit
Wed Jun 11, 2008 3:00 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: APT_ParseError
Replies: 6
Views: 5549

Its a known bug in datastage . If i describe it correctly, if you trim a column while using it in any statement or calculation, it throws this error .

Search the forum on your error, it will give you a lot of posts regarding this.
by Krazykoolrohit
Wed Jun 11, 2008 2:51 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: executing a set of sql queries in a job
Replies: 24
Views: 10007

Re: executing a set of sql queries in a job

Is there a way that i can execute a set of sql queries from a single job. I mean i have the queries in a text file and i want to execute them on the oracle database. I can do that manually..but i want to create a job and keep it in the sequencer? i/p is file with queries and o/p stage should be dat...
by Krazykoolrohit
Wed Jun 11, 2008 2:49 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: executing a set of sql queries in a job
Replies: 24
Views: 10007

What i did was to keep the SQLS seperated by ';' in a text file and then used a sequence to read the file ( with ; as delimiter) and trigger a loop based on the number of records read. the loop ran a job whose only purpose was to fire the SQL to database.
by Krazykoolrohit
Mon Jun 09, 2008 2:00 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Reading Fixed length record file
Replies: 9
Views: 6542

instead of three, just define one column as char (40).

Define delimiter and quote character as none and read your source file.
by Krazykoolrohit
Mon Jun 09, 2008 1:43 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Reading Fixed length record file
Replies: 9
Views: 6542

read the whol record as char (40) and then concatenate into three columns.
by Krazykoolrohit
Mon Jun 09, 2008 11:08 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: APT_ParseError
Replies: 6
Views: 5549

is there any transformer in your job? and are you performing a trim function anywhere.
by Krazykoolrohit
Mon Jun 09, 2008 10:52 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Merge stage mapping error
Replies: 3
Views: 2187

I dont think its explainable.

Have you tried to repeat the scenario by mappping C->A again.

does C contain nulls?