Stack Overflow
Stack Overflow

Questions tagged [information-server]

9 questions
6
votes
3 answers

Is there a way to use User Activity Variables to store SQL in Datastage

I am considering using RCP to run a generic datastage job, but the initial SQL changes each time it's called. Is there a process in which I can use a User Activity Variable to inject SQL from a text file or something so I can use the same…
arcee123
  • 101
  • 9
  • 41
  • 118
1
vote
1 answer

IBM Datastage reports failure code 262148

I realize this is a bad question, but I don't know where else to turn. can someone point me to where I can find the list of reports failure codes for IBM? I've tried searching for it in the IBM documentation, and in general google search, but this…
arcee123
  • 101
  • 9
  • 41
  • 118
1
vote
1 answer

How to export a Datastage job in UNIX

How to export a Datastage job in Unix Machine, I have tried using the following tools. istool used only for the .isx format. dsexport is used for windows client. Is there any possibility to export a job to .dsx in UNIX machine
chintuyadavsara
  • 1,509
  • 1
  • 12
  • 23
1
vote
2 answers

Configure pretty url iis 7.5

I want to use pretty url on my application. I'm using Yii 1.1 (Php framework) and IIS 7.5
Dan Santana
  • 27
  • 6
0
votes
1 answer

ibm infosphere metadata asset manager updates to assets by source

I am starting a new information server (version 11.7), and i did my first import of metadata int o the metadata asset manager then import into datastage. Here's where I am having issues. What happens if the source table changes? Is there any point…
arcee123
  • 101
  • 9
  • 41
  • 118
0
votes
4 answers

How to compile a Datastage Job using Execute Command Stage or Routines in Datastage 11

I am trying to compile the datastage jobs using the Execute Command stage in datastage 11 or any Routines if possible. My datastage is on Unix machine. I tried the following links to go, but I don't know how to do…
chintuyadavsara
  • 1,509
  • 1
  • 12
  • 23
0
votes
1 answer

Running DSODB on Netezza

I'm looking for guidance or instructions to allow Information Server's DSODB database to be located on a Netezza Appliance. has anyone been able to do this? I realize the guidance say ORACLE, MSSQL, and DB2, but if anyone knows how to put it on…
arcee123
  • 101
  • 9
  • 41
  • 118
0
votes
1 answer

DataStage error - Oracle ORA-03135 connection lost contact

In DataStage 9.1.2 I am getting this message error when I try to extract some data within a Oracle Connector ORA_MONTO: The OCI function OCISessionEnd returned status -1. Error code: 3,135, Error message: ORA-03135: connection lost contact Process…
Angel Doza
  • 1,096
  • 1
  • 18
  • 34
0
votes
1 answer

Continue sql stored proc processing in spite of exceptions

I have to capture the exception message which occurs when the stored proc is executed. In the below stored proc, the proc executes and captured the first exception encountered. However, I the stored proc exits once the exception is encountered. Is…
user5704279
  • 19
  • 9