DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 550 matches
Author Message
 Topic: ORA-01017: invalid username/password: Logon denied
Krazykoolrohit

Replies: 5
Views: 3746

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Jun 17, 2008 1:46 pm   Subject: ORA-01017: invalid username/password: Logon denied
Check if the DSN name you are using actually points to the Database you want to run your SQLS from.
 Topic: Reading file with multiple header and trailer
Krazykoolrohit

Replies: 1
Views: 924

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Jun 17, 2008 1:44 pm   Subject: 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 co ...
 Topic: Datastage admininstartion Presentations if any
Krazykoolrohit

Replies: 4
Views: 1472

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Jun 17, 2008 1:41 pm   Subject: Re: Datastage admininstartion Presentations if any
admininstartion

Never heard of this word.
 Topic: Regarding EnvVariable
Krazykoolrohit

Replies: 5
Views: 1536

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Jun 17, 2008 1:38 pm   Subject: Re: Regarding EnvVariable
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?
 Topic: fixed length file format/mapping
Krazykoolrohit

Replies: 2
Views: 1185

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Jun 17, 2008 1:35 pm   Subject: fixed length file format/mapping
If I follow the lenths in transformer, see lengths then it is wrong.

what does this mean?
Resolved
 Topic: How to check the white spaces in a field of Char 40 Bytes
Krazykoolrohit

Replies: 1
Views: 966

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Mon Jun 16, 2008 12:55 pm   Subject: How to check the white spaces in a field of Char 40 Bytes
try the following:

If left(AREA2,2) = ' '
then ('AB':right(AREA2,len(AREA2)-2) )
Else AREA2
 Topic: aggregator sort method issue
Krazykoolrohit

Replies: 19
Views: 11739

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Jun 16, 2008 10:42 am   Subject: aggregator sort method issue
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.
 Topic: Reading Fixed length record file
Krazykoolrohit

Replies: 9
Views: 4281

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Jun 11, 2008 3:02 pm   Subject: 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 dat ...
 Topic: APT_ParseError
Krazykoolrohit

Replies: 6
Views: 3684

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Jun 11, 2008 3:00 pm   Subject: APT_ParseError
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 y ...
 Topic: executing a set of sql queries in a job
Krazykoolrohit

Replies: 24
Views: 6274

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Jun 11, 2008 2:51 pm   Subject: 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 ...
 Topic: executing a set of sql queries in a job
Krazykoolrohit

Replies: 24
Views: 6274

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Jun 11, 2008 2:49 pm   Subject: executing a set of sql queries in a job
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 ...
 Topic: Reading Fixed length record file
Krazykoolrohit

Replies: 9
Views: 4281

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Jun 09, 2008 2:00 pm   Subject: Reading Fixed length record file
instead of three, just define one column as char (40).

Define delimiter and quote character as none and read your source file.
 Topic: Reading Fixed length record file
Krazykoolrohit

Replies: 9
Views: 4281

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Jun 09, 2008 1:43 pm   Subject: Reading Fixed length record file
read the whol record as char (40) and then concatenate into three columns.
 Topic: APT_ParseError
Krazykoolrohit

Replies: 6
Views: 3684

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Jun 09, 2008 11:08 am   Subject: APT_ParseError
is there any transformer in your job? and are you performing a trim function anywhere.
 Topic: Merge stage mapping error
Krazykoolrohit

Replies: 3
Views: 1027

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Mon Jun 09, 2008 10:52 am   Subject: Merge stage mapping error
I dont think its explainable.

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

does C contain nulls?
 

 Jump to:   



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours