DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 16 matches
Author Message
 Topic: input parameters pl/sql
tricampeon81

Replies: 2
Views: 123

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Wed May 23, 2018 8:02 am   Subject: input parameters pl/sql
my problem is simple, as I can from a block, pass the value of the variable to the other comonete trasform
 Topic: lost discussion
tricampeon81

Replies: 4
Views: 106

PostForum: General   Posted: Wed May 16, 2018 3:18 pm   Subject: lost discussion
Thank you!!
 Topic: lost discussion
tricampeon81

Replies: 4
Views: 106

PostForum: General   Posted: Wed May 16, 2018 10:29 am   Subject: lost discussion
they deleted it I do not know what it was about jobs Sad can you help me?
 Topic: lost discussion
tricampeon81

Replies: 4
Views: 106

PostForum: General   Posted: Wed May 16, 2018 9:39 am   Subject: lost discussion
DataStage® Release: 8x
Job Type: Server
OS: Windows
Additional info: discussion disappeared
friends yesterday leave a query here and today I was checking and my query is not out. Can I know why?
 Topic: input parameters pl/sql
tricampeon81

Replies: 2
Views: 123

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Tue May 15, 2018 10:53 am   Subject: input parameters pl/sql
DataStage® Release: 8x
Job Type: Server
OS: Windows
Additional info: I need to pass as pl / sql
friends I have a doubt if they can help me

I have the following simple example I leave in a photo



1 select * from table

2 insert into table prueba_mr

that works perfectly what ace is t ...
Resolved
 Topic: validate the existence of a file
tricampeon81

Replies: 9
Views: 208

PostForum: General   Posted: Thu May 10, 2018 12:58 pm   Subject: validate the existence of a file
in a sequence, execute command and parse the results of a ls or similar check is pretty easy for a binary presence answer without waiting on it to suddenly appear.

thank you very much this was what ...
Resolved
 Topic: validate the existence of a file
tricampeon81

Replies: 9
Views: 208

PostForum: General   Posted: Wed May 09, 2018 10:29 am   Subject: validate the existence of a file
fixed filename
Resolved
 Topic: validate the existence of a file
tricampeon81

Replies: 9
Views: 208

PostForum: General   Posted: Wed May 09, 2018 9:13 am   Subject: validate the existence of a file
DataStage® Release: 8x
Job Type: Server
OS: Windows
Additional info: how can the existence of a FILE be validated
FRIENDS FROM datastage I need to validate if there is a file who can show me an example
 Topic: Insert into with pl / sql
tricampeon81

Replies: 3
Views: 154

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Mon May 07, 2018 3:27 pm   Subject: Insert into with pl / sql
pl/sql blcok how a variable happened
 Topic: Insert into with pl / sql
tricampeon81

Replies: 3
Views: 154

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Mon May 07, 2018 3:13 pm   Subject: Insert into with pl / sql
in transformation we need to tell him that now he does not take the field rut but the variable here trasformes stage
 Topic: Insert into with pl / sql
tricampeon81

Replies: 3
Views: 154

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Mon May 07, 2018 12:32 pm   Subject: Insert into with pl / sql
DataStage® Release: 8x
Job Type: Server
OS: Windows
Additional info: Como se puede hacer un inser
amigos tengo este bloque
DECLARE
vs_Rut VARCHAR2(90);
BEGIN
--
FOR cur_1 IN ( SELECT rut
FROM TB_NEON_TMP_COBRANZA_PPASO
WHERE ROWNUM <11)
--
LOOP
DBMS_OUTPUT.PUT_LINE('Imprimo ...
 Topic: Declare select * from dual end
tricampeon81

Replies: 3
Views: 142

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Mon Apr 30, 2018 3:00 pm   Subject: Re: Declare select * from dual end
I need to improve a query and for that I need to use variable before the query
it's possible??
 Topic: Declare select * from dual end
tricampeon81

Replies: 3
Views: 142

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Mon Apr 30, 2018 8:41 am   Subject: Declare select * from dual end
DataStage® Release: 8x
Job Type: Server
OS: Windows
Additional info: you can use a declare
friends within the query section I can use a declare

???
?????
 Topic: ORA-00955: name is already used by an existing object
tricampeon81

Replies: 1
Views: 192

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Apr 20, 2018 9:18 am   Subject: ORA-00955: name is already used by an existing object
DataStage® Release: 8x
Job Type: Parallel
OS: Windows
you know what this error means:

Carga_02..ouput_02: Exception thrown from CC_OraUtils::handleBeforeAfterSQL, file CC_OraUtils.cpp, line 4722: The OCI function executeDirect returned status -1. Erro ...
 Topic: Assistance in getting started in DataStage
tricampeon81

Replies: 6
Views: 266

PostForum: General   Posted: Thu Apr 19, 2018 1:57 pm   Subject: Assistance in getting started in DataStage
thank you very much for the answer, I look for some document that starts from the easiest
 

 Jump to:   



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours