DSXchange

how can i now in version 7.5 removed orphans left over from incomplete job deletions ?

Hi All, me again. i have another problem with the upgrade of datastage from 5 to 7.5. Most of my projects have upgraded ok however i have the following error. Error Calling subroutine: DSR_PROJECT (Action=1); check datastage is setup correctly in project Archive (Subroutine failed to complete succes...

Hi All,

I have just upgraded from datastage 5.2 to 7.5.1A and in the administrator there is no cleanup button for the project. Can anyone tell me where this has gone or if it is now replaced with something else?

Brad

I have an array in a before subroutine that needs to be sorted before i save it out to a file eg
Array<1> = 123
Array<2> = 99
Array<3> = 125

I want to sort the array in the following way:
Array<1> = 99
Array<2> = 123
Array<3> = 125

Hi All,

Does anyone have an example of a bubble sort in a before subroutine?

Brad

Hi,

I am writing a before subroutine to read a sequential file however under certain circumstances I need to reset the pointer to the top of the file. Is there any way to do this or do I need to close the file and re-open it?

Thanks
Brad

thanks for the responses guys.... i will see what i can come with from your suggestions

Hi All,

Do you know of any options on changing the colours / appearance in datastage directory, designer and manager. I want to have different colours / appearance between our development environment and production environment.

Brad

Sorry guys the topic heading was a bit miss leading. I actually want to append the data of one file to another file producing a third file for example: input file1: 1,test,100.00 input file2: 2,test2,125.00 output file3 (result of the append) 1,test,100.00 2,test2,125.00 What is the best way to do t...

i have used the merge stage in DS 5.2 but I cannot get my output to look like below:
1,test,100.00
2,test2,125.00

it comes out
1,test,100.00,,,
,,,2,test2,125.00

any ideas?

i do have a merge stage available but i cannot seem to figure out how to use it.... is there any help/documentation available on this?

Hi All,

Does anyone know how to simply merge 2 files together?
For example I have 2 files with exactly the same format and i want to simply add one file to the other.
input file1:
1,test,100.00
input file2:
2,test2,125.00

output file3 (result of the merge)
1,test,100.00
2,test2,125.00

Brad

not a standard stage supplied by Assential.... It was a custom stage written for DataStage in C by a contractor

Hi All, I have just installed DataStage V7.1.5.A on a new machine and when I run a job with a custom stage I get the following error. tranposetest..TRANSPOSE_0: OLE Initialization failed! The interesting thing is that if I upgrade datastage from version 4 to 5 to 7 the custom stage works OK. Any ide...

thanks for the reply but that does not seem to help. It looks like datastage can connect to the unidata server and database but fails on the retrieval... any other ideas?

Does anyone know what the dshelper subroutine is? has it been upgraded in version 7.5?