Search found 303 matches

by JPalatianos
Tue Jan 14, 2014 1:27 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Mainframe CopyBook question
Replies: 9
Views: 3968

Mainframe CopyBook question

Hi, Has anyone had issues importing copyvbooks with negative definitions? 05 VRUPB1-TOT-XFER-OUT-AMT PIC -9(9).99. and 05 VRUPB1-TOT-XFER-OUT-AMT PIC S9(9).99. both fail on importing the table definition. with the following: ERROR 1 (line 28): 'PIC' PICTURE character string format is invalid. Thanks...
by JPalatianos
Mon Oct 07, 2013 10:16 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ORCHADMIN command for deleting DataSets
Replies: 3
Views: 4473

Thanks Craig I did not think including the quotes would matter but that did the trick!
by JPalatianos
Mon Oct 07, 2013 6:12 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ORCHADMIN command for deleting DataSets
Replies: 3
Views: 4473

ORCHADMIN command for deleting DataSets

Hi, We are running on windows but using MKS to run the orchadmin command with unix style commands to delete our Datasets. I am able to delete a single dataset using the command: $ D:/IBM/InformationServer/Server/PXEngine/bin/orchadmin rm "D:/rldm_psdw/rldm/dataset/DLY_IF_CALC_FACT_DROPS.ds"...
by JPalatianos
Wed Sep 25, 2013 3:53 am
Forum:
Topic: Question on order and hierarchy for importing BI Assets
Replies: 0
Views: 1680

Question on order and hierarchy for importing BI Assets

HI, We are migrating our BI assets from our QA box to our prod box and I have a question regarding the order that these assets should be imported. We have *.tbl (Table/Database assets) *.rdf (Report assets) *.ocl (Collection assets) *.oml (Model assets) I am not sure if we should be importing: DB/Ta...
by JPalatianos
Tue Sep 24, 2013 1:18 pm
Forum:
Topic: ISTOOL export command for BI reports
Replies: 1
Views: 1909

OK...playing around a bit the following worked:

export -dom NJROS1BBLA0967 -u x090842 -p ########## -v -ar "W:\Business Glossary\Infrastructure Support\SSR exports\Reports.isx" -cm '/njros1uw14410*/*.rdf'
by JPalatianos
Tue Sep 24, 2013 12:30 pm
Forum:
Topic: ISTOOL export command for BI reports
Replies: 1
Views: 1909

ISTOOL export command for BI reports

Hi, When I attempt to export the reports..I use the command: export -dom NJROS1BBLA0967 -u x090842 -p ######## -v -ar "W:\Business Glossary\Infrastructure Support\SSR exports\Reports.isx" -cm '/*/*.rdf' This gives me output as follows: Beginning Export [1/171] <null>/Beneficiary Designatio...
by JPalatianos
Thu Aug 22, 2013 5:26 am
Forum: General
Topic: Problem with triggers in the Execute Command Activity stage
Replies: 3
Views: 2449

Hi Sura,
AFter changing the expression to:
Execute_Command_12.$CommandOutput > 0

The job works as expected.

Thank You Very Much for your assistance!!!!
by JPalatianos
Wed Aug 21, 2013 8:57 pm
Forum: General
Topic: Problem with triggers in the Execute Command Activity stage
Replies: 3
Views: 2449

Problem with triggers in the Execute Command Activity stage

Hi, We have a need to send different emails (subject, body and attachments) based on a file condition. We have a simple sequence job with a Execute Command Activity with two links both going to Notification Stages. The command is: "wc -l" with the following as the parameter: "D:\CRM\w...
by JPalatianos
Mon Aug 19, 2013 4:49 pm
Forum: General
Topic: How to redeploy a patch
Replies: 2
Views: 889

Thanks Andy!! That appears to have done it.
by JPalatianos
Mon Aug 19, 2013 10:58 am
Forum: General
Topic: How to redeploy a patch
Replies: 2
Views: 889

How to redeploy a patch

Hi, I was just curious if there is a way to fake the system out when deploying a patch so it does not find that it has already been applied. We have a few PMR's opened with IBM and for one of them they had us deploy two patches (IMAM and MIB rollup 5 patches). The other PMR asked that we upgrade to ...
by JPalatianos
Fri Jul 12, 2013 6:25 am
Forum: General
Topic: Question on Uninstalling Infosphere 8.7
Replies: 4
Views: 3019

I did find the following:

IBM\InformationServer\_uninstall\uninstall.exe

Has anyone used this?
I figured if this gets rid of WAS and Information Server components I can delete the DB2 instance separately.
by JPalatianos
Fri Jul 12, 2013 5:40 am
Forum: General
Topic: Question on Uninstalling Infosphere 8.7
Replies: 4
Views: 3019

Question on Uninstalling Infosphere 8.7

Hi, We were in the process of migrating our 8.0.1 environment to our new 8.7 servers and we just found out that we need to go to version 9.1 to accomodate a Greenplum connector that IBM should be delivering by the end of this year. Going from 8.7 FP2 to 9.1 is not an inplace upgrade so I basically n...
by JPalatianos
Wed Jul 10, 2013 1:47 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Question on MS SQL Server Load stage
Replies: 5
Views: 3138

Thank You..There is no such stage in the Parallel pallete.
by JPalatianos
Wed Jul 10, 2013 1:41 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Best way to search through a DataSet
Replies: 7
Views: 4430

I appreciate all the suggestions!!
by JPalatianos
Wed Jun 26, 2013 4:35 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Question on MS SQL Server Load stage
Replies: 5
Views: 3138

Question on MS SQL Server Load stage

Hi,
I was just curious if there is a parallel stage that is similar to the server stage "MS SQL Server Load".

Thanks - - John