DSXchange

Hi Craig/Ray,

Thank you very much.I understood how execption handler activity worrks.It really helped me.

Regards,
Bala.

Hi All, My Design looks something likes this Exeption hadler------->Job1-Job2--->Job3--and so on I can take only outputs from my exception Handler and the Exception handler variables are used only in the custom trigger condition of any of the activities.I am trying this but.it gives an compile are a...

Hello All, I have a problem.I am using 10 jobactivities in a sequence and I am using Exception Handler in my sequence.But whenever I try to complile the sequence I getting the following "Error Job has no start point defined".I dont know how to proceed further.Anyone can let me how to recti...

Hi Craig,

Thank you very much.Even I had the same thoughts.Now I can work on these lines.

Regards,
Bala

Hi,

Can anyone let me know how to enable the SQL Null Value tab.
I have tried using an account name but its not getting enabed.Do I need to do something to make it enabled.

REgards,
Bala

Hi Thiru/Eric, Thank you very much.I tried the following. APT_ORCHHOME\bin ;C:\Oracle\Ora81\bin;C:\Program Files\Oracle\jre\1.1.7\bin;C:\PROGRA~1\MKSTOO~1\bin;C:\PROGRA~1\MKSTOO~1\bin\X11;C:\PROGRA~1\MKSTOO~1\mksnt;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;;C:\Ascential\ODBCdrive...

Hi Kumar_s/ArndW, Thanks I have used the stage varibale technique to remove duplicates.But here the scenario is I am using composite key to remove duplicates.Thats why I using some unix commands to remove the duplicates.The stage which which allows me to use the OS commands is command stage but that...

Thank you very much.I got it

REgards,
bala

Hello All,

I want to get the unique rows from a transformer stage.I am trying to do this with the command stage.I am issuing OS commands(like uniq,sort) in the command tab but I am not getting the results as expected.Do I need to do something to achieve this.

Regards,
Bala

Hi,

Still I could not resolve it. There is some configration issue with datastage.
Anyhow I am able to read and write the data through DynamicRDBMS stage but I am not sure of the pros and cons of this with Oracle stage.

Regarads,
Bala.

Hello AmeyVidhya/thebird,

It's working fine.Thank you very much.Kindly correct me if I am wrong in my understanding.Is this the case even if we keep seqential file as the target as the data's in link are virtual datasets eventhough there is no utility for that.

Regards,
Bala

Hello All, Kindly let me know where to find the control file path name.I have checked the APT_config_file it's prperly configured. I have copied the script generated in the data set management utility on clicking on the output tab. ##I TFSC 000001 12:13:22(000) <main_program> APT configuration file:...

Hello All,

Sorry for the confusions.It's columns not rows.ie 10 columns in view data and in the dataset management utility it shows 25 columns.

REgards,
bala

Hello All, I am using some transformations and saving the result in a Dataset. I am mapping only few rows to the dataset(eg:25 rows only 10 rows to the dataset).When I viewing the data of the dataset it 's showing me only 10 rows but when I view the same in dataset Management utility it's showing al...

Hi, I have a column with Datatype varchar length 19.It's a date column.I wanted varchar type to be changed to date. I am trying the following. source field-> 5/1/2003 0:00:00 datatype- varchar length- 19 Transform function->StringToDate(DSLink8.First_Due_Date). Result---->********** Any suggestions....