DSXchange

I want to execute bat files on other computer in same network I wrote two bat file. First one is below net use z: \\10.11.xxx.yy\EVENT /user:domain\username "xxxxxxxxxx" I mapped then second bat file net use Y: \\10.11.xxx.yy\DOSYA_OLUSTUR /user:domain\username "xxxxxxxxxx" Y:\EV...

Of course I looked up. I tried so much.
when I send to statement included inverted comma, DataStage deleted inverted comma in my statement.
I used double inverted comma but it hasn't solved yet.
This statements work in our ex-company. I changed some code.
OS of ex-company's DataStage server is UNIX.

Hi, I have a routine to insert job info into database for logging. I generated below statement. "echo EXEC SP_DSJOB_STATUS_BEFORE ( '10084', 'SifreTesti2', '', '9', '2011-02-02 16:45:03','--UNKNOWN--','19000101_000000','','' ); |sqlplus -S USER_1/PASS1234@TNS_NAMES " OS of DataStage is win...

You can increase your parallelism on your Configuration File ( $APT_CONFIG_FILE).

Hi, I want to create a user who just run a job in Directory. Firstly, i created a user on windows not included Admin options then I created a user with Admin Console and assigned this ds user to op user and gave him Operator role. This ds user cant user Designer as i expected but when i connect dire...

But it doesnt work.
when i look sql on oracle site
Select NVL(COUNT(*),0) FROM gen_takvim WHERE TAMGUN= D
because of this, i took Invalid Identifier Error

My routine is below. Deffun DSRMessage(A1, A2, A3) Calling "*DataStage*DSR_MESSAGE" Equate RoutineName To "SQLPLUS" If Trim(InputArg) = "" Then Message = DSRMessage("DSTAGE_TRX_E_0011", "No command to execute.", "") GoTo ErrorExit End DSN =...

Hİ, I wrote a routine to run sql string.I used DSExecute function. When i use below, sql there is no problem. Select NVL(COUNT(*),0) FROM gen_takvim. But i use below, it return errors. Select NVL(COUNT(*),0) FROM gen_takvim where tamgun = 'D' the error is "ORA-00904: "D": invalid iden...

Hİ, I wrote a routine to run sql string.I used DSExecute function. When i use below, sql there is no problem. Select NVL(COUNT(*),0) FROM gen_takvim. But i use below, it return errors. Select NVL(COUNT(*),0) FROM gen_takvim where tamgun = 'D' the error is "ORA-00904: "D": invalid iden...

Hi ray I asked your question to our admin and the answer is below. ---We have no SMTP client. On server side, we grant IP adress to send mail. we havent installed anything on Datastage server. Our system admin gave us an ip adress(smtp server) and They grant Datastage server IP to send email using IP.

Hi, We want to send e-mail from datastage but we havent yet. Our Smtp server is 10.75.75 and we open ports(25 and 587) of this server. I can ping that server but cant send mail. How can i solve this problem? Untitled11..JobControl (DSSendMail): Error when executing command: E:\IBM\InformationServer\...

We've solved the problem with this:

regsvr32 C:\WINDOWS\system32\msvbvm60.dll

Hope to solve your problem too

Is there anyone who fixed this problem ?

We met same error.

We solved our problem
Thanks to everyone.

Problem was;

At the source side (DB2 Stage) a Varchar field has defined with Unicode option, we changed it to Non Unicode and rerun the job. Rowcount has been fixed.

Thanks everyone again

My parameters are YIL( Year) and AY(Month). I am giving same parameter with the query. I am running the job with parameters "YIL=2010" and "AY=2" also running the query same parameters FROM SMODEL.ABM_KAROZET_ABMTA WHERE YIL = 2010 AND AY = 2 I am giving same parameters to job an...