DSXchange

It seems that the problem was caused by value returned by another routine, and that value was used as an input parameter to this routine(compound_periodicity).
There was no null handling statement.
But the question is why datastage doesn't return the phantom or something else in that previous routine?

Now I left only that code: Ans = "" cp = "" If IsNull(account_type) Then Ans = 'Account Type is NULL for ID = ' return (Ans) End If IsNull(book_code) Then Ans = 'Deal Book is NULL for CUSTOMER=' return (Ans) End if isNull(compound_periodicity) then cp = "#" else cp = co...

DSguru2B wrote:

Code: Select all

cp = ''
p = ''
ab = ''

I add that code on the beginning of my routine and I still get the same error :/

I get the following error: <error> DataStage Job 673 Phantom 24706 Program "DSU.chkAccount": Line 44, Variable previously undefined. Zero length string used. Program "DSU.chkAccount": Line 44, Variable previously undefined. Zero length string used. Program "DSU.chkAccount&qu...

Hello, I have an annoying phantom in my routine, I try to find it but I can't :( Please help... Nvl code: If IsNull(arg) Then Ans = default End Else Ans = arg End This is my routine code: DEFFUN Nvl(arg,default) CALLING "DSU.Nvl" Ans = "" If IsNull(account_type) Then Ans = 'Accou...

Client permissions do play a role when compiling job sequences, because some of the pre-compilation is to craft a temporary XML document on the client. ... So how you explain such situation: Compilation of two (which I discover) job sequences went wrong on domain user account, on another account it...

The client permissions shouldn't play a role, as nothing is done on the PC client box - but it was probably the access permissions for the user with which you logged into the server with. Or do you mean that the compile error changes depending upon your local login and not with the userid/password ...

ppalka - I thought I asked twice to check permissions. As a developer you should be in the group which has RW permissions to all the files in the project directory. ... But it was caused by permission on client machine. I had to use another windows account. Previously I used domain account. Now it ...

ArndW wrote:ppalka - I thought I asked twice to check permissions.
As a developer you should be in the group which has RW permissions to all the files in the project directory. ...

thanks a lot

I figure that it is permission issue, because when I logged as another user then it works. What files/directories permision I should set?

ArndW wrote:If you follow the instructions and make sure that no other users are logged it then the operation is safe. If other users are logged in then you might have unusable indices, but you won't lose any jobs or data.

It didn't help ;(
Any other ideas?
Please help

Does MetaStage allow to import metadata about database structore directly from that database? A similar thing that DataStage plugin metadata importer does, when we import metadata about e.g. oracle table. Not through a third-party software.

thanks in advance

regards,
Piotrek

ArndW wrote:If you go to the Administrator command or go into TCL in a terminal session and enter DS.TOOLS the menu will have an option to reindex the files. This might fix your error.

Is that operation safe?

When you change the name, do you do it as a "rename" from the Director/Manager/Designer lefthand screen? This keeps the original entry in DS_JOBS file. If you do a "save as" then delete the original and then rename the copy to the original's name it might work. Unfortunately it ...

I have a problem with compilation of some sequences, not with all. When I try to compile that sequence it doesn't update job control code, i. e. when I put new job in my sequence. When I change the name of that seq then it compiles good, but when I change it back to the previous name, there is the s...