DSXchange

i am using the administrator user which is having full permisssions.
Do i need to create any profile fil or parameter file to execute the dsjob command.

As I tried many times, it is showing as access denied and then i am unable to connect the data stage. Finally reinstalled the datastage and tried. Still we are having the same problem.

Any help greatly appreciated.
Thanks

Thanks Ray for the responce. i have still in my mind datastage 7.5 version. But now using 8.0 also felling the same. when i try to execute the command it is open a window and it is showing a message dsjob.exe is not a valid win32 application in datastage access denied. What i understand from the mes...

Thanks for the valuable information. I have tried all the possibilities but still facing the same. dsjob -server :9080 -username Admin -password 121123 -lprojects dsjob -server : 9080 -username Admin -password 121123 -lprojects dsjob -server SERVER1:9080 -username Admin -password 121123 -lprojects d...

Hi, I am able to run the dsjob command in data stage 7.5 version(OS: windows 2003 server) But i have installed recently datastage 8.0.1 on windows 2003 server. dsjob command is not working. Server name: SERVER1 username : Admin password : 121123 i have observed couple of new things in the new versi...

Hi, I have implemented the SCD type2 using the below link and also based on the dsxchange forums. http://www.obase.com/iis/DataStagev8.pdf?bcsi_scan_ECD903E68216D30C=0&bcsi_scan_filename=DataStagev8.pdf But i am having a error message and job is getting failed. and searched in the forums. found ...

Hi, We have sequence job. Running very slow. First_job --> Second_Job First job--> delete all the rows based on 4 columns (Col1,Col2,Col3,Col4) in a DB2 Table(using DB2_UDB_API stage) Job design Dataset1---> DB2_UDB_API stage Second job--> Insert/Update rows based on 4 columns (Col1,Col2,Col3,Col4) ...

Thanks for the swift response but having the same problem tried two options Option1 ) Directly added Constraint IsNull(Col1) or IsNull(Col2) or IsNull(Col3) Option2 ) First added Stage variable1 then used the stage variable in the constraint STG1--- > IsNull(Col1) or IsNull(Col2) or IsNull(Col3)

Hi, While doing lookup to the reference table i am having below warning message. Message information: APT_CombinedOperatorController(2),0: Field 'Col3' from input dataset '0' is NULL. Record dropped. Data set data : All columns having nulls are allowed Col1,Col2,Col3,Col4 "1000","abc...

First loading into a comma separated file then moving the file into windows through winscp then open with excel and sum of all the values (Format: number( -1234.10 with 2 decimal places)

Manually checking the total sum of the file.

Hi, We are extracting data from db2 and using modify stage converting into string then finally loading into sequential file. Job Design: Db2 stage -->Modify stage -->sequential file stage Source column name : Cust_amount Datatype : Decimal (20,2) Target column name : Cust_amount Datatype : Varchar(2...

Now it working fine with the below options

query type

Generate update action from options and columns tabs

Update action

delete existing rows only


thanks for the help

DB2 Stage: DB2 UDB API Tried with custom sql using two different options. But unable to delete data from a table. Delete from temp_table1 where col1= orchstrate.col1,co2= orchestrate.col2, col3= orchestrate.col3, col4= orchestrate.col4; Delete from temp_table1 where col1= orchstrate.col1 and co2= or...

After taking notes on your valuable suggestions and tried with many possibilities. Finally got the solution on this. this is closed. DSJobCmd = WorkingDir : 'dsjob -server :30012' : ' -run ' : Parameters : ' -warn ' : WarnLimit : ' -rows ' : RowLimit : ' ' : Projectname : ' ' : JobName Thanks, Suresh

Hi, we are able to list the jobs using dsjob command. Resolution: Changed the shell script dsenv path and tested, it is working fine. ${DSJob} -server :30012 -ljobs project_name But now in the server routine we are using the below command to run the jobs Tried with the below options. Option1) existi...