DSXchange

Hi Aruna,

All the requirements are validated and correct. In fact we can install IS8 a month ago, this is a weird problem

Regards,

Hi There, This is one big, the first time IS8 install good, but, after a boot from the machine, WAS never start again. The Log for this: (Aug 13, 2008 4:45:40 PM), Install, com.ascential.acs.installer.utils.JniUtilsSupportAction, msg1, ****** path = jniUtilsSupportInstall/libjniutil.so, getBeanId() ...

Hi There, This is one big, the first time IS8 install good, but, after a boot from the machine, WAS never start again. The Log for this: (Aug 13, 2008 4:45:40 PM), Install, com.ascential.acs.installer.utils.JniUtilsSupportAction, msg1, ****** path = jniUtilsSupportInstall/libjniutil.so, getBeanId() ...

Thanks

I don't think is a license problem, we have another customer with the same routine and driver runing almost 2 years. Any way Im gonna use SQLError() to obtain more detail and share with you.

Be happy!

Hi, In DataStage exists a transform called MONTH.FIRST, it explanation is "Returns a numeric internal date corresponding to the first day of a month given in MONTH.TAG format (YYYY-MM). Example: MONTH.FIRST("1993-02") => 9164" Then you can rest 1 from the result and use oconv to ...

Hi,

Do you try to use:

Command:#seq_path#\#APORIProcessDeleteFile#
Parameter: (what you need inside the script)

Dear Friends, Finally i can explain what is going on....yesterday we re-install 7.5.3 on AIX 5.3, after a complete cleaning of software, still we had the same problem. Today, again re-install but in this installation we DON'T give the Oracle_Home directory, this cause the error "...i can't find...

Hi Craig, The problem is present if i read from oracle 9 or from oracle 10, and don't forget that in 7.5.1 jobs works fine. Now, we are planning a complete installation (do you remember "Format C:"...well...something like that). Let me inform you later about the evolution of these Best Reg...

Hi Craig In one Server there is Oracle 10gR2, in the other is 9.1, Oracle Client is 10.2.0. Privileges from catalog are correct for the user trying to extract data, bu don't forget that we can see date with the View Data option, but job abort when we run it. In the last test, we copy an SQL that is ...

Hi Craig I believe that we test every possible combination, like use schema, use SQL Builder instead of User Define SQL, Create a View with the fields, synonims, and so on. Still the error is present in some jobs and not in others. DataStage only show that error, we try to find more information insi...

Hi friends, Well, this are the errors: Oracle_Enterprise_5: The provided query statement did not prepare correctly; please verify that your statement is correct; statement: SELECT UNQ_ID_SRC_STM from RI where DSC='IMSI' main_program: Creation of a step finished with status = FAILED. I simplify the d...

Dear Friends We are experienced a very rare problem with Oracle Enterprise Stage, de big picture is: a) We have DS 7.5.1 on AIX 5.3, running fine but with some "crash" problems b) The solution was to migrate to DS 7.5.3.1 on the same AIX c) Now, we can see data in an Oracle Enterprise Read...

Just use Aggregator Stage, the firs output fiel must be the "key", with group by this field. For the second choose MIN to obtain the minimun value of the field "A","B",...an so on.... Finally create a third field (column) with the function count for the input fiel "...

Try this in a routine

D=oconv(iconv(Arg1,"DYMD[4,2,2]"),"D/YMD[4,2,2]")
if Arg2<120000 then
S="AM"
end
else
S="PM"
end
T=Arg2[1,2]:":":Arg2[3,2]:":":Arg2[5,2]
Ans=D:" ":T:S

leomauer,

You need to mark "Add checkpoint so sequ...." in the job properties of the sequence, but the most important thing is that only works if you have terminator stages that makes de entire sequence fail when a job fail.

regards,