DSXchange

We have tried all this possibilities, but no luck. I am sure that its not a display issue. We are able to import the code for the first time. the issue is , while importing the second time the import getting stuck. probably it is not able to overwrite the existing code. Table Definition import compl...

We have tried all this possibilities, but no luck. I am sure that its not a display issue. We are able to import the code for the first time. the issue is , while importing the second time the import getting stuck. probably it is not able to overwrite the existing code. Table Definition import compl...

We have only a single monitor setup..

Thank you all for your reply. Here what do we mean by a Second monitor. I could not get it.

Thank you Creig and qt_ky for your reply. We have waited for more than 2 hours to confirm that it is stuck. Yes you are right, A re import will delete the job first and import the fresh code. So, I checked that if I can delete a job. delete works fine. But issue happens only when I re import the job...

Hi All, We are doing Datastage installation on our new Windows server, as the existing server is getting retired soon. The issues is when we import the .DSX file (for entire project) its getting stuck at "Importing Datastage Design" step. This is happening only if the jobs/project already ...

There can be Non Printable ASCII charecters in mainframe. Datastage may not be able to show it as is , as in mainframe. Eg : Low values (NULLS) . try to find out the Hex/ Oct value for these and do a tranformations.

HI,

More easily, You can write an if else statement is tranformer to get this.

Example:

If value=1 then 'January' else
if value=2 then 'February else
if .................
--------------
-----------------
else 'December'

Can't check right now but you should be able to schedule a job to run on 'every' 5th day of the month. Worst case, you can 'Add to Schedule' and pick November 5th, then 'Add to SChedule' again and pick December 5th, etc etc etc. Chulett, Are you sure , You can have these type of scheduling in Direc...

Try changing property of target stage (ODBC) to Sequentail from Parellel. Ther can be performance reducion

Datastage does not have an option for schedling any paricular day of a month. If your server is in Windows you can use Windows Scheduler, for unix you can try writting a script with DSjob run command and schedule it in chronetab. or you can write your logic to trigger thic command in the script itse...

Have you tried after restarting the server. once i faced the issue and restart solved my problem.

Hi All, I was wondering , for the same purpose ie, My Database is SqlServer and i can connect SqlServer database by ODBC EE stage as well as Sqlserver EE stage. And the features seems to be same. Can anybody advice me when we have to go for SqlServer EE and for ODBC EE . Is there any Architectural d...

Hi, Can i capture the error due to which the job has got aborted in mail activity and send the error message in mail. Ex : Suppose my job aborted due to error " Colud not connect to Datasource " . I want to send the failure alert to developers with this message in Body/Subject of the mail....

Sorry Ray , I dont have a microsoft query client. This thing happens only when i use ODBC connector to load data , whereas if i am using ODBC EE stage the correct value is getting loaded.