Search found 59 matches

by dspradeep
Thu Dec 10, 2009 1:29 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Transformer compilation Error-DS7.5x.2
Replies: 18
Views: 7101

Transformer compilation Error-DS7.5x.2

Hi, I have freshly installed DS EE on Win XP machine. The machine has Visual Studio 2005 and Platform SDK installed on it. While compiling jobs which have transformer I am getting the following error. I have serached through all the topics related to this error and tried all the solutions. No luck !...
by dspradeep
Tue Nov 24, 2009 5:18 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: main_program: Fatal Error: Not a v1.1 type: decimal[10,0]
Replies: 3
Views: 1581

main_program: Fatal Error: Not a v1.1 type: decimal[10,0]

I am getting this error while running my job. My Job Design is ESS-->xml-->trans--> Oraclestage Oracle stage field info id --> Number(8) name--> varchar(50) while import this table it's coming like id --> decimal(38,10) name-->varchar(50) Note : I did not change the metadata and this job is designed...
by dspradeep
Fri Nov 20, 2009 12:30 am
Forum: Information Analyzer (formerly ProfileStage)
Topic: Sequencer -- start Loop issue
Replies: 2
Views: 2258

Sequencer -- start Loop issue

Hi , Actually i have more than 100 files in one folder so i need to preocess one by one then how to do it in sequencer. I tried like in exec comm -- ls -m and i given my folder path start loop -- i given count and comma option as well exec comm.output also. condition --> stratloopcount.output <> '' ...
by dspradeep
Thu Nov 19, 2009 7:45 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sql Server 2005 Text Data type Issue
Replies: 3
Views: 1272

Thanks man , this is already in my mind but i thought worst case we can go this one. so i think no otherway i need to go that way only. let us see any other persons did in some other way also.
by dspradeep
Thu Nov 19, 2009 7:42 am
Forum: Information Analyzer (formerly ProfileStage)
Topic: XML Input Stage Issue
Replies: 7
Views: 5931

You specified a relative pathname (no leading "/") and DataStage gave you a pathname relative to the project. Ya i understood after that i given my path without that (no leading "/") . You need to provide a fully-qualified pathname to avoid this default how to give "fully-qu...
by dspradeep
Thu Nov 19, 2009 4:33 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sql Server 2005 Text Data type Issue
Replies: 3
Views: 1272

Sql Server 2005 Text Data type Issue

Hi, We are facing issue with TEXT datatype while importing this field then it is coming like LongVarchar then i have modified the sql query with cast(fieldname,varchar(8000)) then it is working fine but if the data contain more than 8000 then how can i read. That is the problem which we are facing n...
by dspradeep
Thu Nov 19, 2009 4:17 am
Forum: Information Analyzer (formerly ProfileStage)
Topic: XML Input Stage Issue
Replies: 7
Views: 5931

Hi Guys, I got resolved the issue which i faced in Extenal Source Stage. I don't know why this stage intenally it looking some path after that it looking our specified path For ex, if i give the path like pradeep/master.xml then ESS will go and see in the below location C:\IBM\InformationServer\Serv...
by dspradeep
Thu Nov 19, 2009 3:23 am
Forum: Information Analyzer (formerly ProfileStage)
Topic: XML Input Stage Issue
Replies: 7
Views: 5931

But i given in the ESS like below

Code: Select all

 ls /pradeep/master.xml 
Note: I can view this file and if i put cat command followed by this path then i can able to see the content of the xml also so i am not sure why this "//" coming infront of pradeep.

Pls help me
by dspradeep
Thu Nov 19, 2009 1:31 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Logs are coming after 10 min
Replies: 9
Views: 2887

no that is not a multiinstance job. I found the refresh intervel and it is showing 004 seconds.
by dspradeep
Thu Nov 19, 2009 1:20 am
Forum: Information Analyzer (formerly ProfileStage)
Topic: XML Input Stage Issue
Replies: 7
Views: 5931

XML Input Stage Issue

Hi, The below error i am getting when i am trying to run my xml job. my job design is ESS--> xmlInput-->seqfile Note : In XML input, i have selected URL/Path Radio button APT_CombinedOperatorController,0: Fatal Error: Fatal: XML input document parsing failed. Reason: Xalan fatal error (publicId: , s...
by dspradeep
Wed Nov 18, 2009 11:48 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: External Source Stage with Multiple XML
Replies: 10
Views: 3245

we are using DS7.5.1 in UNIX box and DS8.1 in Windows box both servers are using for diff project. when i try <code> ls -t filename </code> command in DS7.5 then i can able to view the file list but the same job in DS8.1 i can't view the file. But MKSToolkit is installed in my Windows server mechine.
by dspradeep
Wed Nov 18, 2009 9:00 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: External Source Stage-- Windows
Replies: 5
Views: 1566

i will mark it as solved sry ya i thought of distingush my question.
by dspradeep
Wed Nov 18, 2009 8:55 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Logs are coming after 10 min
Replies: 9
Views: 2887

what is your refresh interval in the Director?

How do we know the refresh interval in director...

Is everyone seeing this or just you?
everyone facing the same problem in their own job.
by dspradeep
Wed Nov 18, 2009 8:49 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: External Source Stage with Multiple XML
Replies: 10
Views: 3245

sry for asking that silly question ...

i undertood after that ... I have used the command in ESS like below

<code> dir /folder1/file1.xml /b
</code>

but i am getting this below error
External_Source_0,0: Source subproc: dir: not found

pls help me ...
by dspradeep
Wed Nov 18, 2009 8:26 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: External Source Stage with Multiple XML
Replies: 10
Views: 3245

ok thanks then i can go for my previous design itself.

you mentioned that <code> dir with /b </code> but i am not getting exactly. can u pls post exact syndex

thanks for your quick replay