DSXchange

Friends, I have the following problem:

SELECT TO_DATE(TO_CHAR(B.START_DATE,'DD-MM-YYYY HH24:MI:SS'),'DD-MM-YYYY HH24:MI:SS') START_DATE, FROM table1

Output:
23-06-2018 13:50:56

But when you insert it in the other table it does so as:

23-06-2018

Why?

why do you give me this error when trying to erase? 2018-06-08 10:35:34,028 INFO com.ibm.datastage.g11n.DataStageSessionLocale.setISFSessionLocale(DataStageSessionLocale.java:167) - Setting ISFSession locale to 'en_US' for 'B1B453C9-CEEE-4A90-BE97-71BF6878760D' 2018-06-08 10:35:34,232 INFO com.ascen...

my problem is simple, as I can from a block, pass the value of the variable to the other comonete trasform

Thank you!!

they deleted it I do not know what it was about jobs can you help me?

friends yesterday leave a query here and today I was checking and my query is not out. Can I know why?

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 the following https://ibb.co/guRpdy what you need to do is replace the select with an anonymous block pl / sql and go...

UCDI wrote: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 I needed

fixed filename

FRIENDS FROM datastage I need to validate if there is a file who can show me an example

pl/sql blcok how a variable happened

in transformation we need to tell him that now he does not take the field rut but the variable here trasformes stage

I need to improve a query and for that I need to use variable before the query
it's possible??

friends within the query section I can use a declare

???
?????

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. Error code: 955, Error message: ORA-00955: name is already used by an existing object.