DSXchange

I was assuming that the load method mentioned actually lands a temporary data file somewhere in the background. The broken pipe error can possibly be a result of an operating system imposed file size limit (i.e. 2 GB limit). If it aborts within a few seconds then it is probably caused by something e...

If the job is called by another job then the job log in question would mention it. Depending on your user registry type and credential mapping, viewing the job log details can sometimes show you which user ran the job (manually or scheduled), unless they're all mapped to the default dsadm user. The ...

The Courier hasn't bothered me too much over the years, although I do prefer Consolas because out of the fonts mentioned it's the only one that actually puts slashes through zeros to distinguish them from letter O... very helpful for code (and passwords). Another important aspect of code tags is tha...

It should be easy to update the release choices on the drop down menu and has most likely been done at least once before. The release choice on the edit profile page also needs updating. It includes version 3.6, 3.5, 3.1 or earlier. I am volunteering to trace through the existing phpBB software and ...

How quickly does it abort? How large does the file get before aborting? Check for possible operating system file size limits or user-imposed file size limits (i.e. 2 GB limit) on the system where the file is being written. If that's causing the abort, work with your admin to increase or remove the l...

But I was trying to understand the reason why it is not rejected. If the value in integer column is "aa" it is rejecting. Even in the decimal column if i give a value "1 0.20" it is changing it to "001.00" instead of rejecting it. Is there a way to handle thus issues i...

It's not a very common error. You can tell that by searching. Does the stage have a corresponding column defined? A wild guess would be that the newer 9.1.2 version ships with newer ODBC drivers. Do the newer drivers still support the database? Here's a similar error but not much else in common: htt...

What is Alphabase26? It's one of the rare keywords where Google only locates 9 results (one was this topic, others were not in languages I know).

When posting topics, the "DataStage Release" required field choices are 4x, 5x, 6x, 7x, or 8x. Version 9x has been available since Dec 2012. Version 11x is in the works (not sure why they might be skipping over 10x in the numbering)... How about updating the choices with 9x and 11x (at lea...

But still would like to know why the command is not working, is there any other way to write sed find/replace command in before/after subroutine. Are you still on the same Solaris server or has that changed? Are you still able to run the same sed command from the command line OK? I am also wonderin...

I am seeing the same thing: Long reported Startup time ranging from 2 minutes to 8 minutes and production run time of 0:00, day after day. This job is Oracle Connector to Peek stage. In Oracle it selects a dummy row from the dual table. The Before SQL runs 80+ DELETE statements and commits. Apparent...

Here is a sample start script. Substitue in your own paths and values for AAA, BBB, etc. The encrypted credential files are an optional, very nice feature for avoiding clear-text passwords in scripts and process commands. #! /bin/ksh # # Script: # StartISD_AAA.ksh # # Change Log: # MM/DD/YYYY NAME ...

My experience has been that the ISD Consumer role allows user(s) to invoke ALL web services that require basic authentication. I wanted more granular control, out of the box, over the ISD security model just as you mentioned above, so I had opened an enhancement request about it in 2011: APAR JR4074...

It looks like the current directory '.' is not in your PATH. Try running ./dsjob with ./ in front of the dsjob command.

The same question has been discussed on existing topics:

viewtopic.php?t=118466

viewtopic.php?t=84186

viewtopic.php?t=152005