DSXchange

I'm certainly no expert, but I do notice a difference there from the entries I have for Oracle and MSSQL: the userid and password are set to variables, not what looks like encrypted text.

If what you have is standard practice, then just ignore me.

A standard is what is used barely enough such that the developers who come later can clearly see where it was not used.

I started out in the COBOL world 20 years ago, and I will pompously and arrogantly assert that you guys have it easy by comparison.

We use acronym-like designations for stages, and name them with all-uppercase letters. Links carry that designation on the output side of the stages, and we name them with all-lowercase letters. An example: FTP input stage "FTPR_SALES_DATA", with an output link named "ftpo_sales_data&...

Freddie, am I reading this right: Your development tool is DataStage, but the "clients" want this extract-load to run without the DS run-time engine. So, if that's true, then it could be you are being pushed to use the wrong tool. What is your destination? You write that the extract is fro...

I'm currently doing something similar, as follows: Input field varies from integer to string. I convert it to string (VarChar) and in the derivation I put an "empty string" if I want it to be empty instead of zero, space or null. I use stage variables in the transformer for all the interme...

kwwilliams wrote:If your specification provider continues to be unreasonable, then follow FranklinE's advice and set your select stage's Isolation Level to Read Uncomitted. This will work, but is not ideal.

Keith, would you mind explaining why it would not be ideal? Thanks.

Before exploring the excellent suggestions so far, check on any contention issues inside your database. For example, is your select an uncommitted read (UR in DB2) or does it perform a row or table lock? Your update will always fail if there are locks. It will succeed if there are no locks. The equi...

The specific benefits of templates in DS comes from the mere fact that DS developers are still a relatively rare breed. I've been doing DS development for 3+ years, I took the advanced course less than one year ago, and I am the "senior" developer in my neck of the woods. The better the te...

Thank you franklin So I will use the enterprise stage which allows me to read the data from the file. In that stage properties URI ---is this the path of the file? Ftp command---what is this? username,password is the access to the server and the transfer type is ASCII. please verify my doubts in th...

thanks, so the FTP stage(enterprise or plug in) can be used directly to get read the data and transform the data and then load it. something like FTP--->transformer------->DB which one do I need to use? Do I need to talk to the environment support about the permissions to that server? or something ...

Thank you, Shane, for posting an interesting topic. I'm late to the discussion, but I thought you might find some value in this: row, table and instance contentions are old hat in my shop. We have high volumes of both data and users (people and apps). Our DBAs are tasked with managing that, and the ...

I never used ftp stage,can you help me how to use the stage? is it like FTP----->sequential------>transformer----->DB and in the FTP for URI do I need to give the path of that remote server file and any other options to be filled. please let me know The FTP stage can be used to stream your data dir...

Franklin, My response was, indeed, meant to be constructive and I am happy that you took it that way. Thanks, Mike. This is not the first time I've created misunderstanding by taking a conversational appoach by including references to my mood not necessarily clear in my writing, and not necessarily...

Be very careful when you make such statements to such a large audience with no support for your position. Many of the developers/architects/managers that rely on this site for information might take away something that is absolutely 100% incorrect. RCP, when used correctly, is a wonderful tool and ...

Is this possible with runtime column propagation or is using RCP a bad idea? I was going to post a semi-sarcastic reply to this, but with Keith's "offhand" comment I believe it deserves serious consideration: In any business context where the application is expected to evolve over time, i...