DSXchange

Hello All, I have creatde a sequential file with total columns length as 1200 for a record.When I am looking into the file with 'View Data' option , getting a warning stating - 'Data that exceeds maximum length has been truncated'. Can anybody explain me the reason for the same with solution. Whethe...

Thanks, now got it done though a seaprate subroutine I am trying to get the JobStatus = DSGetJobInfo(JobHandle, DSJ.JOBSTATUS) and then checking the status as follows If JobStatus = DSJS.RUNFAILED Then Reply = DSSendMail(InputArg) End but the status check is not working.. Is it something that we can...

I am trying to get the JobStatus = DSGetJobInfo(JobHandle, DSJ.JOBSTATUS)

and then checking the status as follows
If JobStatus = DSJS.RUNFAILED Then

Reply = DSSendMail(InputArg)

End

but the status check is not working..

Is it something that we cant' check the status in the after job subroutine

It might be worthwhile re-installing the SybaseOC plug-in stage using the Package Installer on your server. Do you have Sybase client software installed on your DataStage server? This is absolutel ... Hi all, I could solve this problem, actually i cleared the registry entries form my machine for al...

Ok, then something specific to your installation. I'd suggest you completely uninstall the DataStage client. Make sure the directories it installed are completely removed and then reinstall the client. See if that helps. chulett, Thanks for ur suggestion I uninstalled the client ( both Sybase and D...

chulett wrote:Does this problem only occur for you from your workstation, or is it a problem for everyone?

Yes it is happening only on my machine and all these jobs are working fine on other's machines.

The problem is .. whenever I try to open the SybaseOC stage properties in the server job in any of the environments(dev,uat,prod), the screen gets hanged. I have tried reinstalling the Sybase client 12.5.1 and Datastage version 7.1 but still the problem persists. (These are all old jobs and the syst...

Thanks , this will surely help. :D

chulett wrote:Yup, not a Function but a Link Variable. Which is also where you'll find it explained in the Help - check the Index for links, variables for an explanation of the several that are available. You'll find there are both Input and Output variables, btw.

Thanks :D

Amos.Rosmarin wrote:Hi,

Open your transformer
goto the constraint edit box
right click --> Link variables --> Inputs ....

you'll find it there



Enjoy it

Hello,
I just got information that there is one function by name NOTFOUND. Basically use for look-up purpose.

As it is not documented, i am not able to find any information.

Can anybody guide me as how to use this and what actually it does.

Thanks.

Arndw, Thanks for you help. Apologies, I got message in the Director log itself not Designer. Only this message is coming after setting environment variable set-ups as per the log. Hello - I don't think anyone is going to be able to help you with this, at least until it happens again. It is like say...

Dear All, I got one error in Designer stating " -Controller problem: Unhandled abort encountered in job MappsMDI205ProjectsExtractJob ". The above error occured while job was executing through Designer, the job aborted while running and log is showing this error only. I feel this is some i...

hi, From where i can get the path of schema file as I am not able to locate schema file in my machine. Sure. You can change the metadata or column definition for any stage that can use a schema file AND has column propagation turned on. Two huge limitations. I don't have a complete list of the stage...

Thanks Kumar.
But now my question is , how I can change the schema file in DataStage?Can I change the Metadata of the job without touching the job i.e. with the help of file.

Hi All,
I got to know that with Run Time Propagation we can read Structure(Meta Data) for file from one of the file stored in repository. Can anybody help me by providing information about this stored file and how I am change it to cater different file structure each time.

Thanks,
Anshuman