DSXchange

I noticed in DB2 connector there is no place for Other Clauses. What is the deal? If you select Uncommitted Read is that the same as WITH UR? It is one of the choices like Cursor Stability. ... I am using ODBC data access. There is a Other Clauses, is under Selection tab.. From the reasearch in int...

Hi, i have 2 jobs which look like this. DB2 (ODBC) > Transformer > Text File For first job, in DB2 ODBC > Output tab > Selection > Other clauses > I put WITH UR So in the View SQL, it will automatcially show me the SQL statement eg Select * from tableA WITH UR; For second job, all the same but in th...

Hi all, i have create a simple stored procedure and want to run from DataStage. Can i just use one Stored Procedure stage to do it? I have try to use this method but it required input and output which i think is not necessary. Is there any better way i just have something like a StoredProcedure that...

Hi, i have a column has this kind of text: This house is belongs to Andy This car is belongs to Kelvin I want the column return me the result of "Andy" & "Kelvin", which means I will only start to take the string after it read "to " Any idea how to do do it? Thanks!

chulett wrote:Two ODBC links, one for the delete and one for the inserts. Make sure only the first row goes to the delete link before it goes to the insert link. ...

Sorry, you mean ODBC --> Transformation --> ODBC (delete) --> ODBC (Insert)?

I want to load data into a target table that it has time_key (yyyymm). I may reload data few time to this table. For second time reload, i need to delete the data which belong to the same time_key to avoid duplicated record. Currently what i am doing is i create a job Seq file > Transformation > odb...

Thanks, it works..by the way, is this code missing the proj name and jobname at the end? And what FORM5500 %1 for?

Great! I just add in -domain <servername:9080> and it works!
Thanks!

I just got the solution in viewtopic.php?p=377446.

I need to create a sigon.file in order to run the batch file. May i know is it a neccesary to create this signon.file?

Im having this problem as well, anyone has solved it?

This is my final code in the batch file @ECHO ON dsjob -server bi_server -user admin -password 123 -run bi CLS EXIT After i double click, it 'seems' working but prompt command closed very fast. When i check the director, this job is not running.. I have put this 2 batch files in server, location is ...

But my job is put under BI > Jobs > Backup
Then how it will know which one to take and run?

If without putting -wait , will it still run?

I have copy the code and put in the batch file.. @ECHO ON dsjob -server BI_Server -user admin -password 123 -run BI/Jobs/Backup/ TEST_NELSON CLS EXIT The save this batch file to C:\IBM\InformationServer\Clients\Classic, where the dsjob.exe is located. Then i execute it, C:\IBM\InformationServer\Clie...

But i want to create a batch file to run it when i double click, instead of using command prompt...Actually i will schedule Windows to execute this batch file...so should i copy this code into the batch file? Will it be the same? And when i try to run it in command prompt, it said dsjob is not recog...

Ok, got it! dsjob -run [ -mode [ NORMAL | RESET | VALIDATE | RESTART ] ] [ -param name = value ] [ -paramfile filename ] [ -warn n ] [ -rows n ] [ -wait ] [ -stop ] [ -jobstatus ] [ -userstatus ] [ -local ] [ -opmetadata [ TRUE | FALSE ] ] [ -disableprjhandler ] [ -disablejobhandler ] [useid] projec...