DSXchange

http://www.dsxchange.com/viewtopic.php?t=105102&highlight=ldedit Hi , I am sandeepgs's friend. we tried the ldedit but ldedit is not for HP UX. But we tried changing the kernel tunable max_mem_window from 0 to 40 and reboot the machine. still the same issue. we have also tried the folowing step...

Can you rename the job you are tring to overwrite? If so, does the import give you the same error? Does your userid have RW access to the DS_AUDIT file in the project directory? If yes, then the error might lie in a corrupted DS_AUDIT hashed file, but I would say that the access rights are a more l...

You cannot rename jobs from UNIX. You could change the name in the DS_JOBS entry for that job but would need to do so from within the ds shell or from the admin tool. Your best bet would be to find so ... Hi, I am not able to see your post completly. I got the GUI access now and when i try to impor...

Do you get the error if you don't update the job but create a new one? this means renaming the original to something else before running the import. ... I dont have access to datastage GUI so I am not able to delete the job. when I try to rename it from UNIX side using UV and update DS_JOBS but whe...

Hi, while importing the dsx file I am getting teh following error. Starting import for executable of job: JsSPHIS_Historique_Solde_Prepaye ...Temporarily renaming previous job 'JsSPHIS_Historique_Solde_Prepaye' to 'JsSPHIS_Historique_Solde_Prepaye$temp$' ...Creating new job 'JsSPHIS_Historique_Solde...

And as Kryt0n pointed out, your syntax is wrong. Check Appendix B of the Parallel Job Developer's Guide pdf for the 'type conversion functions'. Hi Craig Hulett. tried all the things u told me. its still the same. the thing is in the sequential file stage itself its rounding it off. ex 22 55 is an ...

ShaneMuir wrote:Will the Num function work in this instance? ie Num(column)

I tried If Num(Column)=0 then Column else 1
Now all the fields are getting populated with 1.

Kryt0n wrote:try IsValid('decimal', column)

tried this too same thing as before.

Have you tried logically rejecting them by checking with the IsValid() function? Curious if that would work in this case. ... I used the IsValid(column,%ab.cd%) now everything is coming as 00.00 in the output. we can try doing a substring but that will be a very large thing to do. Is there not an e...

The Job looks like this. SF---------Trasformer--------------DS The sequential file has data in a decimal field as '22 55' actually this data has to be rejected because its a space in the decimal field. But it reaching the ountput the same way '22 55'. what do i do to stop this. one example the input...

I have tried everything mentioned in the thread.
its not working. so you are saying there is no way to get it.

I tried this but this query gives a lot of details.
I need only the table name and the DB name.

select EVAL DS_JOBOBJECTS."@RECORD<29>" from DS_JOBOBJECTS where DS_JOBOBJECTS.NAME ='JxZZEXT_TYP_FACT_ENCS_DECS';


Thanks,
Samyam

Hi,

I have a list of inactive jobs in the project.
I want to know the tables these jobs are using.
the tables may be source or target tables.
and the tables are teradata enterprise stages.

How do i get the list of tables in the project.

Thanks,
Samyam

Hi,

I ran the uvsh from the DSEngine Directory, It worked fine but now i am getting the same error with a diff file name.

/usr/lib/dld.sl: Can't open shared library /builds/DStage.Build/server/release/uv/unix/lib/libgciudt6.sl
/usr/lib/dld.sl: No such file or directory

Any idea on this one

Hi,

I am trying to run uvsh.
But it gives an error message saying
/usr/lib/dld.sl: Can't open shared library ./uvdlls/libUtilWSClient.ls
/usr/lib/dld.sl: No such file or directory

Can someone tell me what i should be doing.

Thanks,
Samyam