DSXchange

hi in my parameter file i am writing the parameter name it self like, $APT_CONFIG_FILE=/opt/Ascential/DataStage/Configurations/2Node.apt InputDir=/home/source/ InputFileName=emp.dat OutputDir=/home/target/ OutputFileName=emp.out RejectDir=/home/reject/ RejectFileName=emp.rej then i am passing it to ...

Hi all I am using shell script S1 to call the datastage sequence. I am writing all job parameters in a parameter file and script is using this parameter file. In my main script i am calling a small shell scripts to launch the datastage sequence and providing input that parameter file. in small scrip...

Hi Rick,

could you please tell how did get rid off $ sign.

Regards

please install the c++ compiler into your machine,

for that you can install visual studio 2003 in your PC, it will solve your problem.

hello

you can use BigInt in the datastage table definition to support oracle datatype integer, it will remove all of your warning messages.

Regards

add one more specificaion into Modify satage

and write NOWARN , it will not issue warning messages.

first correct your expression to get correct required ouput format in yyyymmdd, Incorrect= DateToString(StringToDate(DSLink8.a,"%dd%mmm%yy"),"% yy%mm%dd ") Correct =DateToString(StringToDate(DSLink8.a,"%dd%mmm%yy"),"%yyyy%mm%dd") now check the datatype for thi...

hello,

you can use the Parallel Operator sepecefic enviornment variable
APT_ORAUPSERT_COMMIT_ROW_INTERVAL to 0,

Use this variable in job parameter and change the default value to zero.

and check your job.

i want to know few more details about the join conditions,

what are the column you are using to join, \are these column have index or not ?. are u performing join in sql or using DS join stage

Hello Resham,

you can use the below command

dsjob -logsum #PrjectName# #JobName#

it will give you the datastage director log.

Regards,

hi ,

try this option to remove the old link with the new link.

hello Mahadev, it is very tricy to remove duplcicate records using transformer stage, to do that , you need to use two stages, 1) Sort Stage : you need to sort your indatcoming data based on key attributes on which you want to remove duplicate records, also enable KeyChange options inside the sort s...

Hello Tej,

can you please write down a flow diagram of your sequecer activities in sequece,

Based on your previous post,

you are aborting your sequecer incase of failure of your job activity.

what actully you want if your ur job abort.

Regards,

Ray, Thanks for quick response,

I have not column defined 426 in terget and no column defined 425 in the source dataset.

i am not able to figure out why this warning messages is coming.


Regards

Hi All, I am loading records into database table using oracle enterprise stage with sql load options. This datasatge job was not issuing any warning messages in the director log. today it started issuing a warning messages "EmpLoadJob: When checking operator: Formatted length of fields and reco...