DSXchange

hi

Check the date size , i hope that you are having a clear idea that in general date format is DD-MM-YYYY as its size is of 8 characters , but in your requirement you had specified as 7 characters where we will get a problem when the the give date is of 2 digit length .

RK

Hi All

I Apologize for wrongly posted in TX Forum

and

Thanks for your valuable Response

RK

Hi All Can any one give me a suggestion to resolve this problem. here is my routine Function getstr(Arg1) SubString = Trim(Arg1, ""","A") Ans=SubString Return(Ans) what i am trying to do is to eliminate the " [ double Quote Character ] in the given string. Ex : "Lo...

Hi Ray

Thanks for your response

But i am not working on MPP , what ever the work i am working is on a single machine where the server and the client has been installed.

Can you guide me what might be the problem

Thanks in advance

RK

Hi In my view there is some problem with .NET Framework, kindly reinstall the .Net Frame work. When you try to install a DS client , first it will check for the available .Net Framework or it will install it. Can you specify me your OS Environment and what version of Datastage you are using. Thanks RK

Where (designer/director) and when (runtime,save,open,add) are you seeing the error message? If you save-as another name does the new one have the same error? I had done this on designer , while saving the sequence i am getting this problem, i tried to save the same sequence with another name , it i...

Hi Thanks for sharing your ideas Actually i had placed 10 job activitys on the sequence canvas and ran the sequence . every thing is fine and data has been populated to the subsequent target tables. on the same canvas then i added another 8 job activitys , when i try to run it then it is throughing ...

Hi, Initially created a JOBsequence with a few sequence, these are independent with no dependencies, but When adding more jobsequences(with no dependencies) to the exsisting one i'am seeing this error message :?: ============================================== Error calling subroutine: DSR_RECORD (Ac...

Hi Folks

Can anybody share their idea about this problem

RK

Hi Can any one share me the knowledge how to handle date field extracting from flat files. Here i am getting error like "Transformer_3: ORA-01830: date format picture ends before converting entire input string" Actullay my source is in yyyy-mm-dd HH:MM:SS.SSS target table format is oracle ...

Hi Ray

What would be a precise Length if i had to populate data into a sequential file which is of Fixed width format , consider if there is a Decimal(7,4).

Please guide me

Thanks in advance

RK

Hi
Based on the values defined for Read Cache and Write Cache the performance of Hash File can be increased. This can be defined based on the available Hardware Setup

RK

Hi Had u check the status file, most of the time clean up resurces will work but some times the job is killed but it will be shown the stautus of running There is a way to resolve this is to restart the DS Server so that jobs which are hanging will be killed or cleared. Try this one provided u had a...

The problem which u had defined is similar to scd type 2 method, hope u can resolve it , i didn't find where u had strucked up exactly so that i can give my inputs

RK

Hi There is another option available in datastage server jobs but i am not sure that will be possible in parallel jobs you have to write a piece of code for the job which is using the job parameters compile the job which is using the job parameters and after the compilation open the job control tab ...