DSXchange

hello Everyone, I have a quick question, is it possible to write $PROFDEF for the value of a password in the job properties of a sequence, if I give the real value of this password in environmental value in the administrator? or should we use #$PROJDEF# I am very confused also if you could help me w...

kris007 wrote:I prefer DRS to ODBC , for some of my tables I cannot see data using ODBC properly, I get all ????, might be some setting problem I am not aware of but DRS works very good for me .

I thought DRS is slow, never tried though.

imbos123 wrote:I need to coonect to MS SQL server to get data from the tables. Which stage I should use for it. I am using Datastage parallei edition and installed on UNIX.

ODBC stage, however you need to have corresponding records in your odbc file in DS home directory in unix, anything else?

Not sure. The Sequential stage in PX can support bringing in multiple wild-carded files without having to cat them together. However, I don't know if it can supply just the filename of each file rather than the file's data. If that's the case, you can use the URL method in the XML Input stage. Or r...

is it a basic transformer stage or regular?

No ecase is some thing like serial number given for each case logged against the product. So ther should be some number, say ecasennnn which will denote the problem for this player temination, logged by someone. I started searching, but could not find in my new PC. But it should be with my bacukup....

Hi, Iam using a basic transformer stage in a job , when a job aborts due to error raised by routine in basic transformer stage , when I try to reset the job and run it again it is aborting again saying the following error BASIC_Xfom_RL_Not,0: The runLocally() of the operator failed. To run the job ...

Thank you guys, I guess I am the only Turkish person here,

My Favorite part is

mctny wrote: How can a slim chance and a fat chance be the same, while a wise man and a wise guy are opposites?

Also make a note that, if any job is making use of LinkInfo function will also enventually fail. Because, information of LinkInfo is obtained from Monitor. You can ask for ecase directly. Some one who dealt with this can provide it, else I ll search and provide the same. is it the name of the patch...

You cannot straight away goahead and clean up all the resource displayed in the DS director. If your are sure about nothing is been used or no job is running, it is better to restart the server once. There is a bug in the (Java code) Job monitor. As you might have aware, by canging the time based m...

Here are more reasons to change the official language of the forum, :) oh no not to Hindi or chinese, but to Turkish :) English Language There is no egg in eggplant, nor ham in hamburger; neither apple in pineapple. And while no one knows what is in a hotdog, you can be pretty sure it isn't canine. ...

here is one of the player termination topic, viewtopic.php?t=101628

you can try cleaning up resources through Director, or set Disable_job_mon to true,

I believe this is a DS bug which happens intermittently, so I really suggest you to contact them,

thanks
Cetin

Hi Kumar, IBM also suggested the same thing as you are? no I haven't made that change in our production environment because the jobs are running fine recently, since I cleaned up the resources and I am not getting player termination error. what are the consequences of doing that, do you have any ide...

Hi Cetin, If you can post your PL/SQL stored procedure, it will be much easier for me to figure out how to code a parallel job to do same thing. I did already in my previous message, thank you for reminding me. at first I thought it is a long procedure but it wasnot that long. it is not complex eit...

yes there is more to it, here is one of the stored procedure I need to convert it to a parallel job ( not by just calling the procedure from a stored procedure stage as a whole) CREATE OR REPLACE procedure sp_load_top_five_rfs is VN_TRANS_AMT NUMBER(14,2) := 0.00; VN_TRANS_COUNT NUMBER(15) := 0; VN_...