DSXchange

Anybody used the script Duke's DataStageExport.bat to export the whole project..I am getting errors regarding the directory structure. Bad/Non-existing directory: D:\DatastageBackups\KiranTest Please ensure that you have permission to access/create directories and files. Also ensure that directory l...

if anybody used the file Duke's DataStageExport.bat script for exporting a project..please give me suggestions. I am getting the errors regarding the directories i use in the script.

Thanks

just to let you know..i am doing this for parallel jobs

I posted some new scripts on the 2 links below my sig. The new script was DataStageExport.bat. Do a search for this. Basically it requires a JobList.txt file to be setup in a folder with the project name. This list of jobs will get exported one at a time. There is a similar command for importing th...

i have done this on my test database (on my PC). It is working and i have to test this on the real database...once once i am done with it , i will tag it as resolved!

thanks for all the suggestions.

can you let me know how the mapping is done. i am getting the following errors: ODBC: When checking operator: When binding output interface field "DUMMY" to field "DUMMY": Converting nullable source to non-nullable result; fatal runtime error could occur (use modify operator to s...

i am not able able to run the test connection. the tns service name is correct and i am giivng the DSN of my wish

hi i am trying to create an ODBC connection from DS server on windows 2003 to an oracle database on win XP. i keep on getting the error ORA-01017: invalid username/password: Logon denied. But with the same id and password i am able to login through sqlplus. Any suggestions here?

Thanks

the first stage would be a ODBC stage with a user defined SQl. The SQL can be anything that returns atlest one row and can trigger teh job. Lets say it can be select 1 from Dual. The column defination can be a single column temp. Pass thsi column to the next stored procedure stage. in the stored pr...

I need to give a presentation regarding the datastage for some of the teams who are interested in this product. Can someone please give me some tips or any good documents so that it will be helpful in presenting this product.

Thanks in advance

Is it not possible to create the procedure if my userid has the privileges through a role instead of direct privileges for tables? Even after granting the privilege "create Procedure" i am getting into ORA-01031-insufficient privileges errors I came to know in order to compile the procedur...

all the sql statements are update statements. each query update a "comments" column of long data type in different tables. Since datastage cannot handle lond datatypes and i have to use go with this process on all the tables that has a comments column with long type. Does this makes sense?

i have to ask the database team if they allow me to create a procedure on their database. Once i do this, i will let you know.

Thanks for all your responses!

the first stage would be a ODBC stage with a user defined SQl. The SQL can be anything that returns atlest one row and can trigger teh job. Lets say it can be select 1 from Dual. The column defination can be a single column temp. Pass thsi column to the next stored procedure stage. in the stored pr...

as you said it should be like

odbc stage------> store procedure stage right?

Where you can use the sql procedure in the odbc stage? should i need to select user defined sql and include the procedure there?

Then what column definition i should use?