DSXchange

Hi all, I am encountering some weird error in the Transformer during compilation. ##W TFCP 000000 20:22:28(007) <transform> Error when checking composite operator: Implicit conversion from source type "Decimal" to result type "DFloat". Currently, the transformer has 156 number of...

Basically, I want to get rid of warnings like below:- mdf_DropColumn_ICIR_GO_INTER: When checking operator: When binding output schema variable "outRec": When binding output interface field "key_subr_ir" to field "key_subr": Implicit conversion from source type "st...

Hi all, I am trying to convert a integer datatype into varchar datatype using the Modify stage to prevent the warnings to appear in the Director Logs but after using the statement 'lookup_ustring_from_int32', the job immediately stopped due to severe error. Below are the error logs I encountered wit...

Thanks for all yr help, Chulett!! :oops: Actually your instructions worked, just that I missed out removing some of the Ascential registry stuffs. I finally did a find of the word 'Ascential' and deleted all of it's records, restarted and reinstall again. Now it works!! :D Really appreciate all your...

only my pc.

chulett, i have followed yr steps but still the stage properties can't open. i have discovered that the server jobs are all ok but the parallel jobs are the one that i can't open especially the stage properties for file sets, data sets, sequential files. :( ray, everytime i re-install, i also instal...

Hi all, I was using the DataStage Designer for the whole day and all of a sudden, my system froze whenever I opened the any Stage Properties. I have tried uninstall and re-install for 2 times but still nothing seems to work. Does anyone know what is the problem? I suspect some file is corrupted in t...

So, by setting those variables to TRUE, the Director log will show all the information on this? Will it cause any performance problem by doing this?

Hi all,

Just want to check with y'all whether DataStage has the capability or program hidden somewhere that is able to monitor the job running with details of the server memory and the space left and all?

Is everyone talking about the datasets residing in the destination folder set in the DataStage jobs itself or the DataStage/Datasets folder? We too face the full space problem. What are the folders to clean up for maintenance? Seems that even when it is cleared everyday, the scratch space is still f...

Thank you all..... :D

Hi all, I have always wonder how does people know what are the syntax and detailed description of all the commands in the Job Control tab. Eg. DMGetParam, DSLogInfo, DSLogFatal. There has to be some reference somewhere. Even for all programming languages, there has been references online on the synt...

Hi all, We are using a BASIC Routine to execute a SQL script and retrieve the input and pass into the next job. Now, the problem is the retrieve input is a STRING datatype but I need it to be a NUMBER datatype instead. Is there anyway to convert the input from STRING to NUMBER in the Basic Routine? ...

Yeah, I am encountering a similar situation. I was hoping to pass in the column names through some routine? Is that possible then? Has anyone written such routines before? In other words, we just want to achieve some dynamic table loading.

Hi all, I have the following groups in the UNIX:- - dstage - dsopr I have read that permission access to the DataStage is divided by groups. Therefore, I created the 'dsopr' group to have only access to the DataStage Director. After assigning 'user1' to 'dsopr' as the primary group and 'dsopr', 'dst...