DSXchange

Hi Ray,

Thanks for the info....

So where should we use and execute these queries??
DELETE UV.ACCOUNT 'Project'
DELETE FROM UV.ACCOUNT WHERE @ID = 'Project';

Is it in DS Admin Command prompt???

Regards,
senthil Kumar P

Hi Ernie,

The problem here is i am unable to login to the Adminstrator because of this issue. So i am not able to create new project.

Thanks for all your help...

Will get in touch with Support provider and update you...

Senthil Kumar P

Hi All, Thanks for your replies.... I tried using the Delete command, DELETE UV.ACCOUNT 'DWTest' DELETE FROM UV.ACCOUNT WHERE @ID = 'DWTest'; But i couldnt get the tables UV.ACCOUNT in the Xmeta database. also there is no schema called UV. Please let me know from where i can query this. Find the lis...

Hi all,

Any update please...Thanks,

Senthil P

Hi All, When i was creating a new project in Administrator, due to some issue in unix server, my DS adminstrator got closed abruptly. So the project has not created completely. When i tried logging again to the adminstrator it throws error message related to the project which i was creating. So i de...

Thanks Ray and DSDexter..I got it.


-Senthil P

Hi All, Please let me know what is this error? "node_node2: broadcastStepIR: score file write for 4096 bytes to file /tmp/APTps901232091bcdf0 on node node2 returned -1; errno = 28 (file system full) Consider setting TMPDIR or APT_PM_SCORE_DIR to a directory with more space." main_program: ...

Hi, Yes, Its Service Pack 2 in my machine. There are DS clients installed on other machines for the same server and they are able to access all. But we installed 3 more clients recently and this was fine for a week and suddenly this issue has happened. Please let me know what to do for this. Thanks

Hi Sai, Please see the version details Product installLocation="C:\IBM\InformationServer\" key="datastagedocs" name="datastagedocs" version="8.0.1.0" /> <Product installLocation="C:\IBM\InformationServer\" key="datastage" name="datasta...

Hi Chulett, I tried unistalling the client and removed it from regedit and then installed it freshly. Again i am facing the same issues " run Time Error 1000" when i open any routines. Unable to open the stages in sequencer as well some of the stages in individual job. Please help me resol...

Hi Chulett, Thanks for info..

I reinstalled without uninstalling my old client and tried but again i am facing the same issue.

Should i unistall my client and then install? Will this resolve the issue.

Thanks,

Senthil P

Hi, In DS client I am unable to view the stage properties in Sequencer. Also when i open the stages in job level it allows me for some time and many times am getting the error called OLE. Whenever i open the basic routines, i am getting the "run time error 1000" Invalid option when bound. ...

HI,

Please search for the Job Unlock, there are enough answers given.

Anyways, you can release it thro director. In the director, go to job cleanup resources option and then search for the name of the job to get your PID. Unlock the same.

Thanks,

Senthil P

Hi Anurag, I am not sure whether this is the correct one..try this.. If you are checking isnull constraints in transformer for the fields that are from lookup table...then see whether it is a nullable field..if not then the is null constraints wont restrict the records... normally we get null values...

Hi All, I am trying to update a table using the userdefined query... UPDATE Table SET col4= ? WHERE (col2=? And Col3=?) Message: 0 rows affected... The columns in the where clause are not the key column in database...but in datastage i enabled it as key..even in the where clause if i add primary key...