Search found 100 matches

by shiva459
Thu Nov 14, 2013 11:03 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to read PIC -9.9 in complex flat file
Replies: 5
Views: 3597

Re: How to read PIC -9.9 in complex flat file

Declaring the data type as PIC +9.9 or PIC -9.9 is perfectly valid in Cobol world but DS is not able read it.Change the copy book to PIC X(4) for that field and try reading the source file.
by shiva459
Mon Oct 20, 2008 2:13 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: WAS launched but failed initialization
Replies: 18
Views: 15954

I faced similar issue with WAS on windows. I was able to start the WAS service manually but it would stop again after clicking refresh. Later I found that this was an issue with my trial license validity. Please check the license expiry as first step. Another issue would be with the user name/pwd. C...
by shiva459
Mon Oct 20, 2008 2:12 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: WAS launched but failed initialization
Replies: 18
Views: 15954

I faced similar issue with WAS on windows. I was able to start the WAS service manually but it would stop again after clicking refresh. Later I found that this was an issue with my trial license validity. Please check the license expiry as first step. Another issue would be with the user name/pwd. C...
by shiva459
Mon Oct 20, 2008 2:10 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: WAS launched but failed initialization
Replies: 18
Views: 15954

I faced similar issue with WAS on windows. I was able to start the WAS service manually but it would stop again after clicking refresh. Later I found that this was an issue with my trial license validity. Please check the license expiry as first step. Another issue would be with the user name/pwd. C...
by shiva459
Mon Oct 20, 2008 2:08 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: WAS launched but failed initialization
Replies: 18
Views: 15954

I faced similar issue with WAS on windows. I was able to start the WAS service manually but it would stop again after clicking refresh. Later I found that this was an issue with my trial license validity. Please check the license expiry as first step.
by shiva459
Fri Sep 26, 2008 10:08 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle EE Plug-in
Replies: 2
Views: 1942

Parallel read is supported only on a non-partitioned or range partitioned source table.
by shiva459
Mon Aug 25, 2008 12:31 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Operational Metadata in Version 8
Replies: 0
Views: 790

Operational Metadata in Version 8

I'm trying to compile job stats (start time, end time,rows inserted, rows rejected,rows updated,errors reports etc.) for all the jobs in my project. I'm able to generate most of the information from web console but would like to know if it is possible to trace the SQL behind the report. My idea is t...
by shiva459
Sat Jun 21, 2008 12:22 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: File Pattern in Sequential Stage
Replies: 3
Views: 1329

File Pattern in Sequential Stage

Hello I'm using file pattern in sequential file stage but facing issue with column names. File1 Name,Job abc,Manager File2 Name,Job zyx,President I'm getting out put as abc,Manager Name,Job zyx,President I have picked first line is column name as true. How to skip the column names from other files?....
by shiva459
Sat Jun 21, 2008 11:27 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DB2 configuration
Replies: 4
Views: 1916

sreddy, I have been reading your posts and none of them have pointed answer. This forum is to get tips and resolutions from experts and people who have faced and overcome similar problems in the past. I appreciate if you stop responding to a query unless you know something about it. If you are still...
by shiva459
Sat Jun 21, 2008 10:23 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem with ORCHADMIN
Replies: 15
Views: 7532

Craig, Yes, it is orchadmin.exe in windows. $ cd D:\IBM\InformationServer\Server\PXEngine\bin $orchadmin.exe rm testfile.ds orchadmin.exe : not found If I try the same thing from windows prompt D:\IBM\InformationServer\Server\PXEngine\bin>orchadmin.exe rm testfile.ds The environment variable APT_ORC...
by shiva459
Sat Jun 21, 2008 9:52 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem with ORCHADMIN
Replies: 15
Views: 7532

I'm not able to find dsenv file on my machine. Is something new in version 8?
by shiva459
Sat Jun 21, 2008 9:45 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unix commands on 8.0
Replies: 4
Views: 1588

apologies.. you do not even have to do what I said below. Just go to windows command prompt and you can run all unix commands provided MKS is installed
by shiva459
Sat Jun 21, 2008 9:43 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unix commands on 8.0
Replies: 4
Views: 1588

open command prompt on windows and enter sh, you will get $ prompt - you are all set.
by shiva459
Sat Jun 21, 2008 9:18 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem with ORCHADMIN
Replies: 15
Views: 7532

I tried this : APT_ORCHHOME="D:\IBM\InformationServer\Server\PXEngine" export APT_ORCHHOME Now echo $APT_ORCHHOME D:\IBM\InformationServer\Server\PXEngine cd bin pwd D:\IBM\InformationServer\Server\PXEngine\bin orchadmin rm testfile.ds orchadmin: not found Not sure if there is any setting ...
by shiva459
Sat Jun 21, 2008 7:51 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem with ORCHADMIN
Replies: 15
Views: 7532

Below is the output from echo command
echo APT_ORCHHOME
APT_ORCHHOME