DSXchange

Hi! Please inform which in stage you intend to parameterise column. For eg if you are usind a db2 database stage DB2/UDB API then you simply need to put '#<Job Parameter>#' in Output --> Column --> Derivation and it would fetch the value of job parameter in that column. Or you can modify SQL to inc...

hi all, I wanna parametrize the column level field. How to do that? I've searched the forum but i couldn get any thing regarding this stuff. Consider if A & B are my columns and if '123' & 'abc' will be the default value for A & B columns respectively. The default value may change or may...

The quickest way is to open your Administrator client and delete the project. DataStage will not work without metadata so, if you want to delete metadata, you also want to delete DataStage. Try to ... No ray... hope you couldn get my and i might have not given you the proper information. sorry for ...

hi all, actually where exactly the meta data ll be stored in the repository? I jus wanna go through my Unix box and i wanna delete it. I can clear up the columns through table definitions option in Designer itself. but i wanna do the same through Unix box. Like log reports which is stored under RT_L...

You've got a syntax error in one of your Transformer stages. It could a line with a trailing = sign, or a missing quote, or use of a reserved keyword. ... I couldn't get your point. Could you pls. elaborate and especially about the reserved key words? Your time ll be highly appreciated... Thanks in...

kcbland wrote:Is your project file system full? Usually this is a bad thing. ...

Yes kcbland... I've checked the same after some time and i've cleared some spaces in my project Now am able to do everything... Its because of Space problem only.

Thanks for all your inputs.

Thanks again
veera...

kcbland wrote:Is your project file system full? Usually this is a bad thing. ...

Yes kcbland... I've checked the same after some time and i've cleared some spaces in my project Now am able to do everything... Its because of Space problem only.

Thanks for all your inputs.

Thanks again
veera...

hi all, am really weird cos sometimes i can able to create a copy of a job but sometimes not. When am trying to create a copy i got an error saying that "cannot create RT_CONFIG<job number> and error calling subroutine failed" and moreover its saying that cannot create the file. Could any ...

hi all, Am getting the following error during compilation "Compiling: Source = 'RT_BP2912/JOB.1080363902.DT.1478852905.TRANS3', Object = 'RT_BP2912.O/JOB.1080363902.DT.1478852905.TRANS3' ************************************************************************************************************...

Cleanup Resources is only valid if there are active threads on the job. If you try to cleanup a job that has finished, what would be there to cleanup/logout? No... what i meant to say was even though am running the jobs, Clean up resources didn't show the jobs which are currently running.. So what ...

Cleanup Resources is only valid if there are active threads on the job. If you try to cleanup a job that has finished, what would be there to cleanup/logout? No... what i meant to say was even though am running the jobs, Clean up resources didn't show the jobs which are currently running.. So what ...

Hi all, In my data stage director, active process are not been shown when i go though the "Clean up resources" option. What might be the cause for it? I've searched the forum but i got an alternate solution to Release the job and the error might be because of set up in data stage. What mi...

trobinson wrote:This looks like a good general explanation:
http://openqm.com/HTMLobj-79/Dynamic_Files.pdf

hi robi,

i couldn get the file from the path that you have mentioned. could you help me out to get the same?


Thanks in advance
veera..

I will assume that "cud" meand "could" - OBJ files are not a known ending of any files used in DataStage. ... hi Arndw...Thanks for your reply.. Could you tell me in detail. or suggest me a material regarding this. I jus wanna know the stuffs regarding OBJ files. I mean, what is...

Can you explain what didn't work? DataStage server internal time is an integer (number of seconds since midnight) so it will sort correctly. If you somehow declare this as a character then it will not sort appropriately, so part of the question back is to ask how you are sorting. no.. If i sort the...