DSXchange

Nothing on your machine, drop the odbc stage on your canvas, open its properties, go to output tab, go to columns tab and click on load. Click on Import...'odbc table definitions'. From the drop down list in 'DSN' you should be able to see the entries that are in the two entries. Chose the one you w...

you need to add entries to two files. uvodbc.config and .odbc.ini on the server. Search this forum for exact details on 'how to'

It depends upon the 'inhouse' standards. But as a general practice, its not outside the boundry of 'best practices' to access different databases in a single job.

What are you trying to achieve? Are you trying to connect to a database via odbc stage? Need more info then what you are providing buddy.

What is the length that you have specified for char? Change it to varchar and see what happens.

I stumbled across Vincent's blog entry. Check thisout. For both, interviewer and interviewee.

This has been discussed time and again, and again and again. This is one example.

You dont have to. It will just be faster. Or you can do everything in user defined sql. Something like select MY.id,MY.name,MY.location,MY.country_id,MY.region_id, C.country_name, R.region_name from myTable MY left outer join country_table C ON MY.country_id = C.country_id left outer join region_tab...

No problem. Small tweak to the stage varialbe 'counter', which is as follows:



Go to the stage variables property and specify the initial value of 'counter' as KeyMgtGetNextValue('YourJobName'). Your done.

Phantom process is a DataStage internal process. Thats the high level definition. A zombie is a process from Freddy Vs. Jason. Just messing with ya. Click here

These are two distinct lookups. Build two hashed files. One from country_table keyed on county_id and the second from region_table keyed on region id. Perform both the lookupn on those keys in one transformer. Its a regular lookup. I dont see the confusion.

Test it out. See what is the performance gain if any. Let us know too. Its hard to tell as we do not know what you are doing in modify.

Well, i guess then the OP needs to either convert the format explicity like he/she has been trying or as Craig said, use Dos record end setting. Check out thislink for a few more ways of doing that.

Are you using a 'Source' procedure type ? Did you check the 'Procedure returns multiple rows' box. Thats one way, the other way is to implement it within Datastage. Study what the stored procedure is doing and implement it with a simple database stage.

Well, I have always created test files on my desktop and ftp'd them over to the unix environment. Just a simple put command. It would convert it. No special command to convert it along with ftp. That is due to the fact that command line ftp uses ascii transfer mode as a default mode. The recieving m...