Search found 221 matches

by cosec
Tue May 31, 2011 11:43 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Lookup not working as expected
Replies: 5
Views: 4192

Lookup not working as expected

Please advice if there is any special handling that needs to be done for character fields using a lookup after migration for v8.1
by cosec
Mon Apr 11, 2011 7:52 pm
Forum: General
Topic: Unable to export Datastage project
Replies: 5
Views: 2424

Thanks.
by cosec
Mon Apr 11, 2011 7:38 pm
Forum: General
Topic: Unable to export Datastage project
Replies: 5
Views: 2424

Hi Ray,

The error we got when we tried to log in was "Failed to authorize user against the selected doman SECJ0395E: etc...."

is there anyway we can export the DS jobs without login credentials ?
by cosec
Mon Apr 11, 2011 5:28 am
Forum: General
Topic: Unable to export Datastage project
Replies: 5
Views: 2424

Unable to export Datastage project

Hi All, We are unable to log in to the datastage console (Datastage Designer, Administrator etc..). We were told my IBM that it is probably because the xmeta is corrupt. However, we were able to run the datastage jobs from the command line. I need to take a backup of the project. So, I tried the fol...
by cosec
Mon Apr 11, 2011 3:39 am
Forum: General
Topic: Where are the Datastage Job designs stored.
Replies: 1
Views: 1197

Where are the Datastage Job designs stored.

Please advice on where exactly the datastage job designs are stored and the role of the XMETA repository...Thanks.
by cosec
Mon Apr 11, 2011 3:37 am
Forum: General
Topic: DSexport location
Replies: 1
Views: 1819

DSexport location

Hi,

I am trying to obtain a backup of my project and unable to execute the dsexport command. please advice the location of the dsexport file.

I was not able to find it in the following location:
/var/dstage/Ascential/DataStage/DSEngine
by cosec
Mon Apr 11, 2011 2:35 am
Forum: General
Topic: Unable to log in to Datastage
Replies: 6
Views: 3788

I just noticed that I am able to run my jobs. It's just that we cannot log in to the consoles. I will try to do a backup from command line. thanks.
by cosec
Mon Apr 11, 2011 1:39 am
Forum: General
Topic: Unable to log in to Datastage
Replies: 6
Views: 3788

Hi Ray, We are not able to log in to the any of the consoles (Administator, Designer etc.) We were advised by IBM that the XMETA repository was corrupt and that's why we are not able to login. We were told to do a clean re-install. Since we do not have a backup of the recent changes, we would like t...
by cosec
Sun Apr 10, 2011 9:50 pm
Forum: General
Topic: Unable to log in to Datastage
Replies: 6
Views: 3788

Unable to log in to Datastage

Hi, We are currently encountering the following error: Failed to authenticate the current user against the selected domain. Unexpected end of file from server. Upon checking, we were informed that the xmeta file was corrupt. Is there any way how we can retrieve the datastage jobs ? Please assist. Th...
by cosec
Tue Mar 01, 2011 2:49 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Extracting multiple occurences in XML file
Replies: 3
Views: 3727

Extracting multiple occurences in XML file

I have an xml file with repeated info such as the following. example: <PRODUCT_INFO> <PROD_CD>PROD_CD1</PROD_CD> <PRODUCT_INFO> <PRODUCT_INFO> <PROD_CD>PROD_CD2</PROD_CD> <PRODUCT_INFO> I am required to store the first occurence (i.e. PROD_CD1) under a Field A and the second occurence (i.e. PROD_CD2...
by cosec
Tue Oct 26, 2010 12:22 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: What does "Validate input XML" in XML Input stage
Replies: 1
Views: 1069

What does "Validate input XML" in XML Input stage

I would like to find out what does "Validate input XML" in the XML Input stage does ? Please advice.
by cosec
Mon Oct 25, 2010 11:46 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to export/import XSD
Replies: 3
Views: 2381

i meant the xsd..

based on the xsd i need to check if there are validations for certain columns.

e.g. column QTY can accept values between 1.00 and 10.00 only.
by cosec
Mon Oct 25, 2010 9:39 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to export/import XSD
Replies: 3
Views: 2381

How to export/import XSD

Hi,

I would like to find out how to export/import xsd from an XML stage Thanks.

Regards,
Hazmar
by cosec
Fri Jul 09, 2010 1:33 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Max Value of Length property for a LongVarChar Field Type
Replies: 2
Views: 2054

Max Value of Length property for a LongVarChar Field Type

Hi All, In our current process to handle MQ messages, in the MQ component the message is defined as LongVarChar and in the length field a value of 9999999 is specified. Is there any limitation on the value for this length field? From what I checked it allows a max length of 999999999. Please help co...
by cosec
Tue Jun 15, 2010 8:54 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Datastage Character Set
Replies: 1
Views: 3344

Datastage Character Set

Appreciate your advice on the following:

1. How do I find out which character set is being used ?
2. How to change the character set to UTF-8?
3. Can the character set being changed for a particular job only ?

Thanks,