DSXchange

Hi Gurus, probably i feel that was not enough information i have given to expect some thing. what iam doing is that iam trying to extract data from universe, since my work extensively involves working with universe and i cannot find in manuals, even tried different other ways. As iam extracting the ...

Hi Gurus, As we are into better understanding of universe, you people have helped me a lot, but still need to identify some objects in universe. j\1\root j\2\root j\3\root ... ..... .... iam getting LINE NUMBER 15 LINE NUMBER 16 LINE NUMBER 17 is not available for all the records. in DS_ROOT again i...

hi GURUS; when creating odbc connection i have given the following parameters. i have choosen SYSTEM DSN and selected MICROSOFT ODBC DRIVERS FOR ORACLE. There are options to specify the datasource name, server name, user name and additional options to increase the performance but no options to test ...

hi, yaa i was able to connect to oracle normally, but there too i just gave user name and pass word, didn't give the service name ie CONNECTION STRING NAME.I creates DSN but there is no option to check the connection there itself, there is no option to test the connection while creating DSN. plz gur...

Hi, iam working on stand alone system. iam dealing with oracle database. when i use odbc to connect to oracle, TNS SERVICE CANNOT BE RESOLVED. i went to services checked the TNS SERVICE and turned on. went to odbc.ini file and seen it is configured correctly. searched for dshome directory where the ...

hi, yaa data stage server repository resides on universe. similarly parallel version too. the arcitectural are of no difference. handling metadata has noting to do with datastage server or parallel version, every thing depends on schema. this is to my knowledge, prob gurus can give you more detailed...

Hi, one of my friend is asking me can we upgrade server version to parallel version. i said him its not possible , we can upgrade from one verion like 6.5 to 7.0. this is what we call as VERSION CONTROL concept. plz let me know, since i never heard something like upgrading server version to parllel ...

hi gurus; when i use the command LIST.DICT DS_JOBS; iam getting the query o/p as @id D 0 name D 0 readonly D 1 oletype D 2 i understood that its displaying the column names- metadata information. but what does 'd ' mean and what does 0 here means. plz help me cheers; vijaykumar

Hi Gurus, one of my team member is saying that using the command SORT.DICT DSJOBS, we can extract the entire metadata of the objects in the universe.is that correct. why is my command SORT.DICT DSJOBS returning error, comes up with the error message VERB SORT.DICT is not in your VOC. i could underst...

Hi Gurus, we are working on data stage server edition, during installation i found that datastage repository resides on universe, where does the parallel version repository resides on. we are working with universe, can anyone explain me plz where does parallel version repository resides on. my manag...

hi, Thanks very much, i didn't get any error but the query is not displaying o/p, it doesn't comeup with errors but doesnot give any o/p. i have tried the other query also, i have given. select @ID,NAME "JOB_NAME",OBJID,OBJTYPE,OBJNAME,OBJIDNO FROM DS_JOBOBJECTS where @ID like '%ROOT' and ...

Hi Gurus;
plz help me

iam tying from the command interface.

select @ID,NAME "JOB_NAME" where @id like '%ROOT' from DS_JOBOBJECTS.

why is my select statement not working, is that the syntax error.iam getting below error

ERROR:illegal use of verb select.

cheers;
vijay

from the command line interface iam giving command select @ID,NAME where @ID like '%ROOT%' from DS_JOBOBJECTS, iam getting error unexpected verb token was taken was "SELECT" scanned was select.
anyone help me plz.

cheers;
vijay

when iam using the command select * from DS_JOBOBJECTS its displaing object type j object record id 1 object record name v1s1p2 object type l object record 3 object record name vos5 how can i identify these objects. i didn't understand the terms. what is meant by object type and which is the source ...

Hi, The thing is that we are into developing a product, universe has data from various sources like informatica,business objects. when i give command line utility select * from DS_JOBOBJECTS.its displaying incomplete records.it displays the connection information, but the structure of data is withou...