Search found 53 matches

by anandkumarm
Wed Feb 06, 2008 3:06 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Loading NVarchar Fields into SQl server 2005
Replies: 2
Views: 2548

Hello,

Thanks for the response, the culprit in our data was a special character which looks like an apostrophe but its not once that character has been cleaned everyhting works fine.

Thanks,
Anand.
by anandkumarm
Thu Jan 31, 2008 12:23 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Loading NVarchar Fields into SQl server 2005
Replies: 2
Views: 2548

Loading NVarchar Fields into SQl server 2005

Hi, I am trying to load english data into a NVarchar field in a SQL server 2005 Database Table. I am using ODBC stage and NLS mapping is set to none. For certain records I am getting the following warning and the records are not loaded into the table: DSD.BCIPut call to OCONV failed. Column: Phrase,...
by anandkumarm
Thu Dec 27, 2007 9:47 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datastage log in issue Version *
Replies: 7
Views: 6084

The "REINDEX ALL" only applies to the DS Engine and that is not where your problem lies. I would certainly talk with the system administrators about what they did; it does seem to have affected your repository connectivity. What error do you get when you try to login to Websphere via the ...
by anandkumarm
Thu Dec 27, 2007 9:07 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datastage log in issue Version *
Replies: 7
Views: 6084

With Version 8 the metadata repository is not longer exclusively within the DS Engine - and your error message indicates that something has changed with your access rights to the repository. a) What database is your repository in? Is that database up and running? b) Has someone changed the Webspher...
by anandkumarm
Thu Dec 27, 2007 8:35 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datastage log in issue Version *
Replies: 7
Views: 6084

Datastage log in issue Version *

We installed Version 8 almost 10 weeks back .Every thing was working fine till yesterday.From yesterday no one were able to log in .It gives an error message saying"""///Failed to get groups for user(Suiteadmin).Unable to begin a transaction.error opening repository.Error initializing...
by anandkumarm
Thu Dec 13, 2007 8:43 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: file Pattern
Replies: 0
Views: 1565

file Pattern

Hi
i am using sequential files to use the file pattern property...but as it is sequential it is very slow...Just wanted to know if there is any other way of using a file pattern in Dataset or Filesets...heard that you can do it using File sets...is there a way to do it with File sets???
thanks
by anandkumarm
Thu Dec 13, 2007 8:33 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: FTP Stage
Replies: 3
Views: 3373

HI

Thanks for the respose.. I got it working
by anandkumarm
Thu Dec 13, 2007 8:24 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: routine inactive
Replies: 2
Views: 2950

routine inactive

HI , Iam able to use the existing routines.when i try to modify or when i try to even view the code in the routine its grayed out. I am not even able to create a new routine.I went to File>NEW>ROUTINES>SERVER RoutinES... the code area is not allowing me to enter any code its not activated. Even save...
by anandkumarm
Wed Dec 12, 2007 2:24 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: FTP Stage
Replies: 3
Views: 3373

FTP Stage

HI I am using the enterprise FTP stage..i am giving the syntax as ftp://ip[port]/xxx/xxx/xxx and the id and password of the destination system ans selecting the command as ftp.. but it say invalid syntax.... As far as my knowlege the syntax is correct can you help me know what else i shouldbe doing ...
by anandkumarm
Fri Dec 07, 2007 11:02 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: log information
Replies: 5
Views: 3216

Re: log information

HI Try using dsjob -logsum <project_name> <jobname> if that is what you are asking for Thanks Hi, Is there any method for getting job names and there ids which are in the sequencer.i.e when i run sequencer i want to collect the log information of sequencer which has sequencer id,job ids,jobname,seq ...
by anandkumarm
Wed Dec 05, 2007 4:35 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: error with Oracle stage
Replies: 1
Views: 3057

error with Oracle stage

Hi I am having a problem with OraOCI stage when I try to view the data <Oracle_Enterprise_0> Error occurred during initializeFromArgs(). Incorrect dboption list; it failed on Expected "," or "}", got: "$", line 1. Creation of a step finished with status = FAILED. I am a...
by anandkumarm
Fri Nov 16, 2007 5:01 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Start Loop activity
Replies: 5
Views: 3613

It would help if you actually asked a question. :? There's no need to 'change the file', have your process that reads in those values and sets them in the Start Loop change the delimiter. For example, perhaps something like this would help: EReplace(YourList,@FM,",") Thank you for the Res...
by anandkumarm
Fri Nov 16, 2007 2:31 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Start Loop activity
Replies: 5
Views: 3613

Start Loop activity

HI I have a problem with the start loop activity. I have a file on the unix box which has values aaa bbb ccc ddd eee the format of the file cant be changed to a comma seperated or anything else....I want these values to be passed into my job activity after the start loop one after the other my job l...
by anandkumarm
Tue Nov 13, 2007 11:17 am
Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
Topic: DS Admin's please help me
Replies: 8
Views: 6329

DS ADMINS

hi, As Eostic said it is better to leave the ports default as they are, rather than trying to manipulate them. I just had to default the ports as they are and it is said to be configured and working as expected to. Thanks & regards Sudhindra P S i INSTALLED VERSION-8 .I was able to log in to DS...
by anandkumarm
Tue Nov 06, 2007 12:22 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: transformer stage not working
Replies: 3
Views: 1745

transformer stage not working

HI we installed version 8 on AIX.
I am able to use all the stages except Transformer stages.When i use transformer stage its throwing error at the time of compilation.
Is it some thing related to C++ compiler if so what are the things i should take care of .
Appreciate your help.
Thank you