DSXchange

My server job ends with an ODBC insert into a SQL Server table. Every job run hangs/aborts at this point, and eventually reports: From previous run DataStage Job 22 Phantom 3388 Program "DSD.BCIPut": Line 204, Exception raised in GCI subroutine: Access violation. Program "DSD.BCIPut&q...

Thank you so much! That did the trick. It's really nice to be able to rely on generated SQL for this instead of having to go the user-defined SQL route.

-Bill

This sure sounds like a nice approach to getting the sequence number without using custom SQL, but I haven't yet been able to get it to work. I get errors when I try to view data from the DRS or OCI stage that I created to use nextval. Possibly I've misunderstood some part of the suggestion. I used ...

I've seen a couple of folks asking how to do this, but no one really seemed to know, so I thought I'd ask again. I have a Command Stage (this is a windows server) in which I want to execute an OS command for each record that comes in on the input link. I need to use the column value from the input r...

FYI: I solved the problem, by adding some registry keys/values so that they would apply to the command (pscp) when run in the command stage. In this case, I added the same key structure for the SSH software (to define the cached server host keys) under HKEY_USERS that existed under HKEY_CURRENT_USER...

Thanks for the suggestions. Indeed, I can now see the directory (using pwd) and user (using whoami) that is being used to run the command. But when the pscp command is run using the command stage, it is still asking for interactive confirmation to accept the server host key. This is happening even t...

Thanks for the suggestion. This sounds like it will provide information about the Universe account and environment that will be in use, is that right? If so, I'm guessing that that will not necessarily be the same as the windows user account under which the DataStage server will be running. Please c...

I should have been more clear about my question: Can you please tell me how to figure out the user account that the DataStage server will be running under? If I can determine that, I will try to run the scp command manually using that account in an attempt to get the server's key cached in the regis...

I'm trying to use a Command Stage to run scp to securely retrieve some CSV files from linux box so that they can be processed in a job. I've generated a private/public key pair so that a password will not have to be supplied, and can successfully run the scp command from a windows command prompt out...

First, thanks for suggesting that I use a Sequential stage instead of an ODBC stage; I can certainly do that. I've become accustomed to using ODBC access to CSV files outside of DataStage, so I just assumed that would also be the way to go within a DataStage job. The data file in question is actuall...

Greetings. I am trying to correctly define an ODBC stage to read data from a CSV file. The CSV file includes field names in the first record, and I have generated an associated schema.ini file during creation of a system DSN. I've verified that I can access the data vis DSN outside of DataStage usin...

Thanks for the suggestions. I do indeed have access to Remote Desktop Connection, but this is a bit of an annoyance for me, and does not address the similar needs of other folks who do not have this priviledge, so I was thinking of a perhaps more simple and direct solution. Since the Perl Win32::ODB...

Greetings. I would like to be able to create system DSNs on my DataStage server, but from my remote client PC. This is to just avoid the hassle of getting onto the server for this task. I couldn't easily find an acceptable package to do this, and am think of writing a small client/server app myself ...

Another thing to do, if you haven't already, is to test the ODBC DSN outside ProfileStage once you've created it to be sure it is working as intended. The way I like to do this is using an ODBC-only query tool, like the free version of WinSQL. There are so many other things going on with ProfileStag...

Other factors can also affect throughput for other phases of analysis. For instance, since table analysis looks at functional dependencies among the columns within a given table, the number of columns and the degree to which the column values imply dependencies will affect how many dependencies are ...