DSXchange

Hi there, I am trying to secure passwords as much as possible in the development of my jobs. I am attempting to run a sql script that I call from an execute command stage in a sequence. In this stage I supply the command: sqlplus -s Then I pass my connect information in the parameters section. Every...

Great followup Ray, I have talked to Jim many times. I will see if I can get a copy of his presentation.

Hi everyone.

I just wanted to let you know that the security policy on the computer is what prevented the information server from installing once I had the server group add the users to the policies I listed above, it installed with no problems.

Sean

I did not have any version of DB2 installed before installing this product. Here's the info on the error that occured: 01/09/2007 11:53:36 CREATE DATABASE xmeta ON 'H:' ALIAS xmeta USING CODESET UTF-8 TERRITORY US COLLATE USING IDENTITY USER TABLESPACE MANAGED BY AUTOMATIC STORAGE AUTORESIZE YES INI...

YES YES YES. I have been working with IBM tech support on this for 2 Weeks! Question, Does your local security policy get set via a domain? If so, you need to open it up so that DB2 can do its thing when creating the metadata repository. Here are the settings I have so far that I need to open up: I ...

Does anyone have a solution to this issue?
I receive the same message.

Thanks,

Sean

Hi there,

I was wondering if you could do something like this in a transformer:

if x =1 then
a = "1"
b = "2"
else
c="3"


The key being the multiple assignemnt of a and b.

Hope that's clear.

Thanks

I already have a routine which spits me out the hex equivalent of what is there so, all I did is just check the code that tells me there packed data there and then convert it to decimal, seems to work OK.


Thanks for the help.

I have a cobol copy books that is defined as such... 07 DARATRN-SERIAL-AREA. 007900 09 DARATRN-SERIAL-NBR 008000 PIC X(05). 008100* SERIAL NBR FROM TRANSACTIONS 008200* PACKED UNSIGNED - 10 DIGITS 008300* 008400 09 FILLER PICTURE X(03). 008500* 008600 07 DARATRN-RATE-CHANGE-AREA 008700 REDEFINES DAR...

From what I have heard most people send a trigger file after the file you want to monitor for transfer is complete. So, you would monitor for the trigger file and then start your job.

Hope this helps

I asked something similar, but I'm not sure I clarified this well so let me try again... I have some data that originally has the following business key: bank varchar2(4) prod_type varchar2(2) prod_sub_type varchar2(2) I would use these fields in a change capture to capture any changes to my dimensi...

Yeah I have had the same results. I would like to see IBM expand this stage to be more useful.

Routines are written in C and then defined in the repository.
On the install CD that you have for DataStage there is some documentation on how you set these up. Look in Samples\TrxExternalFunctions folder.

Hope this helps!

Try to compile it as an object and not a shared object. I could never get .so files to work, but I got .o files to work.

Hope this helps.

Well...
I am running Hawk Beta 2A and this is not the case. Hopefully they fix this by GA?

I guess I will land each occurence to a dataset and load them that way.

Thanks,

Sean