DSXchange

I also tried to run the query from a stored procedure and get this error instead: ODBC function "SQLFetch" reported: SQLSTATE = 24000: Native Error Code = 0: Msg = [IBM(DataDirect OEM)][ODBC SQL Server Driver]Invalid cursor state (CC_OdbcDBStatement::dbsFetch, file CC_OdbcDBStatement.cpp, ...

Thanks jwiles. I am struggling a bit to follow your explanation. It is probably better if you show me some example SQL of what you mean. I tried this and get message "Incorrect syntax near 'fix_hra'" with (select ID,convert(varchar(255),NAME) NAME, version,CONVERT(xml,meta_data) META_DATA ...

I have this SQL statement that runs fine using the SQL Server client: with fix_hra (id, name, version, META_DATA) as (select ID,convert(varchar(255),NAME) NAME, version,CONVERT(xml,meta_data) META_DATA from HRA) SELECT ID, NAME, Version, Q.value('(@id)[1]', 'varchar(9)') AS 'QuestionID', Q.value('(@...

I've got a nvarchar in SQL Server (reads work with UTF-8) and want to output it to ISO-8859-1. Unfortunately not all UTF-8 characters can be represented in ISO-8859-1, so I get 50 warnings and the job aborts. Is there a way to make a best effort conversion and just replace "non-western" ch...

We are facing Designer crashes , lot of times, when working with Sequencers in 7.5.1A . Has anyone facing this kind of issue? Yeah Designer 751A crashes a lot with Sequencers on my machine too. I save soon, save often and hope for the best. What helped a lot in my case was deactivating the "Sh...

Don't know if this related or not... I just got a patch for memory leaks for datetime, numeric/decimal datatypes. We encountered the memory leaks when working with the Sybase, Teradata, and ODBC stages in PX. This patch was for DS751A on AIX. Ecase 76017. AIX+ODBC+Datetime in our case but the leaky...

You can work around it by spliting the feed into multiple files or feeds. I thought about that. It is a real pain to have to split the file in 5 parts and run 5 separate jobs for that though. Idealy you want to split depending on the size of the file because it is likely that the size of the input ...

kduke wrote:You probably have a memory leak. You need to figure out where. It may be in the ODBC driver.

That makes sense. I guess the ODBC stage has the memory leak since it is the one we use the least. They say those memory leaks are pretty common in C++.

Hi all, I have a very simple job that reads a sequential file 40Million rows at 1500kbyte/row= 60GByte. Goes through a modify stage to eliminate a few rows and transform date into timestamp and then loads it into SQL server using ODBC enterprise. As I run the job it increasingly takes more and more ...

I think this change in transformation rule is not possible at runtime in a job but If you think it is possible to do through GUI, then suggestions are welcome :lol: Thanks & Regards dsusr Which got me thinking, and unfortunately I think it is not possible. You could generate the xml for the job...

Ok, after messing arround with it some more I found out the following: 1. If you have one input and one output, RCP and Auto-Transfer do the same thing. 2. All input variables referenced in your code have to be defined in the input interface schema and all output variables referenced in your code ha...

For question 1, the warnings per column are because you are using autotransfer AND have specified an output schema. You need to use one or the other. For question 2, check out the following posting: http://www.dsxchange.com/viewtopic.php?t=93517&highlight=buildop Hope this helps. Brad. Excellen...

Job: Sequential File -> Custom Stage -> Sequential File I created a minimal custom build stage. I use the same table definition for input and output interfaces in the stage and also in the input and output links for the stage in the job. I set autoread, autowrite and autotransfer to true assuming I ...