Search found 49 matches
- Fri Feb 25, 2011 1:04 am
- Forum: General
- Topic: Schedule job doesnt work properly
- Replies: 0
- Views: 1326
Schedule job doesnt work properly
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...
- Wed Feb 02, 2011 2:36 pm
- Forum: General
- Topic: execute oracle procedure in routines
- Replies: 3
- Views: 3043
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.
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.
- Wed Feb 02, 2011 1:57 pm
- Forum: General
- Topic: execute oracle procedure in routines
- Replies: 3
- Views: 3043
execute oracle procedure in routines
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...
- Thu Dec 30, 2010 2:46 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Performance Tuning
- Replies: 9
- Views: 6365
- Fri Dec 17, 2010 6:46 am
- Forum: General
- Topic: revoke delete rights
- Replies: 1
- Views: 1457
revoke delete rights
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...
- Tue Nov 02, 2010 2:14 am
- Forum: General
- Topic: sqlplus routine on windows platform
- Replies: 5
- Views: 12132
- Mon Nov 01, 2010 10:04 am
- Forum: General
- Topic: sqlplus routine on windows platform
- Replies: 5
- Views: 12132
- Mon Nov 01, 2010 9:37 am
- Forum: General
- Topic: sqlplus routine on windows platform
- Replies: 5
- Views: 12132
sqlplus routine on windows platform
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...
DS
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...
- Wed Oct 20, 2010 12:11 am
- Forum: General
- Topic: SMTPMail Server closed the connection!
- Replies: 5
- Views: 3136
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.
- Tue Oct 19, 2010 5:15 am
- Forum: General
- Topic: SMTPMail Server closed the connection!
- Replies: 5
- Views: 3136
SMTPMail Server closed the connection!
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\...
- Fri Mar 19, 2010 7:37 am
- Forum: General
- Topic: QueryInterface for interface VBA._Collection failed
- Replies: 3
- Views: 2776
- Fri Mar 19, 2010 1:49 am
- Forum: General
- Topic: QueryInterface for interface VBA._Collection failed
- Replies: 3
- Views: 2776
Re: QueryInterface for interface VBA._Collection failed
Is there anyone who fixed this problem ?
We met same error.
We met same error.
- Mon Mar 15, 2010 5:57 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Less row count with DSDB2PX Stage
- Replies: 7
- Views: 5478
- Mon Mar 15, 2010 3:31 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Less row count with DSDB2PX Stage
- Replies: 7
- Views: 5478