DSXchange

ArndW wrote:If the hashed file is being referenced, i.e. read-only with no updates, then by all means run in parallel. Each job referencing this file will have it's own memory copy if the file is designated "pre- ...

THANKS A LOT

Hi, Could you give any suggestions on the following issue. I have a hashed file,Which is referenced in 7 jobs ,There is no other dependency exists between these jobs.All the jobs are handling huge amound of data and their exicution time varies from 3hrs to 30hrs depends on the job. I have two option...

Hi please check the output tab in XML input stage..there metadata of file is missing with grammer .Incase any more help need just let me know Thanks..Could you explain the things in detail:How the whole process My EMP.XML file will look like as follows. <EMP> <EMPNO>23</EMPNO> <NAME>ABC</NAME> <DEP...

Hi please check the output tab in XML input stage..there metadata of file is missing with grammer .Incase any more help need just let me know Thanks..Could you explain the things in detail:How the whole process My EMP.XML file will look like as follows. <EMP> <EMPNO>23</EMPNO> <NAME>ABC</NAME> <DEP...

Hi I am very new to " XML stages " in data stage.I have a requirement to convert an XML data file to a text file .i have to create the job in server and parrelel jobs In server job:I have done the design as follows folder stage----->XML input-------->Flatfile But while running it is giving...

1. If you mean a sparse lookup, no - that's only supported for DB2 and Oracle. If you mean a Sequential File stage feeding a reference link, then yes. The contents of the sequential file are loaded ... Thanks.I am beginer in PX.. I tried to create a reference link as well as a primary link from seq...

Hi All Could you look into the following issues with DS PX. 1. Is it possible to perform the lookup into a sequncial file with out craeting the Dataset (i mean direct lookup to the sequncial). 2.Is it possible to do a self lookup( parimary link as well as the reference link of a sequncial file are s...

Hi If you are installing C++ compiler before the Datastage installation then it will automatically search and set the environment variables (COMPILER). If you have already installed the DataStage then first install C++ compiler then go to Administrator and Set the Environment variables (COMPILER) a...

The error indicates that you do not have the c++ compiler installed or configured per the DataStage installation instructions. ... Thanks for the information. Could you calrify 1-Can I install .net (with visual C++) to resolve the issue.If so which version do I need to install? 2-Is it requird to u...

The error indicates that you do not have the c++ compiler installed or configured per the DataStage installation instructions. ... Thanks for the information. Could you calrify 1-Can I install .net (with visual C++) to resolve the issue.If so which version do I need to install? 2-Is it requird to u...

When i am trying to complie the simple parallel job it is giving the following error. My job consits of one sequential file stage as source one transformer and sequential file as target, it is direct mapping from source to target no functions and calculations used in trasformer stage. Output from tr...

Hi All,

Could you tell me How can I run a Datastage job from the Unix Prompt.
I have tried with dsjob command,But It is not working.
1.Please let me know the currect syntax
2.Do I need to run the command from any particular directory

Thanks,
Sudheep

Execute the below command in Unix prompt

od -x /DirPath/HshFileName/DATA.30 | head -1

Will give you the following result

0000000 acef 010c 0000 001e 0000 0000 0000 0001

The bold word shows it is a 32 bit hashed file .
If it is 64 bit hashed file it will show 020c, insted of 010c

Do you get the same error when typing "RESIZE MyHashFile * * *"? Can you do a "COUNT MyHashFile USING DICT VOC"? ... Now i can create VOC pointer without warning msg i have used the following option SETFILE /ABC/PQR/MyhashFile MyhashFile OVERWRITING After that i tried with resiz...

Does a VOC pointer exist for MyHashFileName ? It's hashed file, by the way, not hash file. ... I have the idea how to create VOC pointer .I used the foillowing command to establish the VOC pointer SETFILE /ABC/PQR MyHashFile OVERWRITING [/b] after exicuting the command i got the following messege *...