DSXchange

I wanted to add to this because I was struggling with a similar issue and just discovered the answer. For calling a Target SQL Server Stored Procedure, I had to uncheck the General Procedure Call box and use the following syntax:

EXEC ? = <procedure name> ?, ?, ?, ?

More information more to the point on this question. From the IBM documentation for SAS, the SAS executable location needs to be specified in the configuration file. If we are using SAS/Share the idea is that we would not have SAS installed on the Datastage server. So how would the SAS executable be...

I am adding a link to this post in case this is your issue. Apparently there is an issue if you use an isolation level = "none" for a stored procedure. Switching this to read committed fix this for me like magic.

https://www-304.ibm.com/support/docview ... wg21404686

We are running 8.7, so yes SAS stages are included.

Thank you! That is getting me in the right direction. I guarantee that nothing has been configured between SAS/Share and Datastage yet, but I can work with the SAS administrators to configure. What type of connectivity needs to be configured?

This post is a bit old, but I was hoping to get some more insight from someone on this. We have SAS/Share and I have been tasked with connecting to with Datastage over our network. I am not entirely sure where to start. - Can I use the SAS stage to connect to SAS/Share? If so, can you advise how to ...

We just started using this subclipse too, and it is working well for code versioning. I am attempting to get Packages into SVN as well from Info Server manager but running into trouble. Has any one used subclipse for packages?

Is it possible to then do something like a SQL "LIKE" command?

Here is what I found. In the CFF stage on the File Options tab, change the reject mode to "Save." You will then need to add a reject to the stage. (add a link, right click link, convert to reject) Now any record that does not flow to the criteria you have established will be sent to the re...

Here is what I found. In the CFF stage on the File Options tab, change the reject mode to "Save." You will then need to add a reject to the stage. (add a link, right click link, convert to reject) Now any record that does not flow to the criteria you have established will be sent to the re...

I am seeing a similar issue. This only happens occasionally on a job, most of the time it works fine. The job would stay in a running status until it was manually stopped. Looking at the FTP logs, there is not much to see but what I was able to find was that the authentication to the FTP server did ...

I have a situation I do not see a post on. I have a flat file with multiple record types and record type indicators, so naturally I want to use the CFF stage. I have used this successfully for other files from this company, but now they have thrown me for a loop. The record has a header, contra head...

I wondered if you could add a little more to this. I have the same issue, and I agree that this is a database issue. I will be speaking with my DBAs about new indexes. That being said, I would prefer the Datastage job to timeout and fail rather than simply hanging. If it fails we will get notified a...

Thank you! This helped me as well. Follow-up question, in the old Server edition you could view the data and it would also check to make sure the schema fit as well, but it does not appear to do that in PX. Is there any way to validate the schema in designer without running the entire job?

This has come up on other posts. We no longer have Oconv, Iconv, and FMT in Parallel. There is debate on if there are other functions that peform the same functionality in Parallel or not. Can someone provide a definitive answer, can the funtionality of these functions be done in Parallel with other...