DSXchange

You do realize that it is a 'hidden' file (because it starts with a dot) and you have to specifically use the -a option with 'ls' to find it? I'd be surprised if it's really not there... try:

KCBland can you please explan what do you mean by saying DSJOBS here?? He didn't say 'DSJOBS' he said 'DS jobs' as in 'DataStage jobs'. Run fewer jobs at the same time or try to start fewer jobs simultaneously. Server load can also be an issue if it's busy enough (doing anything, not just DataStage...

Note that you specifically need version 7.5x2 as noted by balajisr, not 7.5.2 or (cough) 7.2.

Your issue is on the SQL Server side. The size of the data in the job itself isn't an issue or you would get a different warning. Meaning, you've defined it as a Varchar(255) in the job and the data there isn't greater than 255 characters. So, that could mean a couple of things. The actual target fi...

You are getting a Data Truncation warning from DataStage or SQL Server? Can you post the actual warning?

Via the DBMS Type selection. Read the Help, it will list which are native and which are ODBC.

And if you mean replace the first character with 'XYZ' - substring.

You might want to give just a wee bit more detail... and an example.

Or for a small number of jobs, double-click on the job in Director and copy/paste from the dialog box. Or check out this post for a way to capture output from a UniVerse query.

I doubt the problem is from the number of records, but you haven't given us much to go on. How about more details about your job? What database are you accessing via what stage? Is there any error number associated with this message? And can you - from the DataStage server, not your client - run the...

And that has been the default on every system I've seen. An 'rc' file is placed out in the appropriate 'run level' startup directory so that DataStage automatically starts when the system comes up into multi-user mode.

You'd need to target a Char or Varchar field in order to preserve the trailing zeroes.

I am using Datastage 7.5 server edition. If you are using the original release of 7.5 then I would think that what you see is what you get. From what I recall, it isn't until the 7.5.1A release that something other than Oracle is supported by the stage and (apparently) the layout of the GUI was rea...

Always wondered what 'readable' meant in this thread since it's a fairly subjective term. Perhaps if 'readable' was actually defined by the OP then more targetted suggestions could be had. Otherwise, pretty much anything you pull from the logs is readable...

The Folder stage is primarily for supporting the XML Input stage, hence the trick of feeding in the entire contents of the file in one field for subsequent parsing. It's not really appropriate for handling sequential files. You are better off doing this via a Sequence job, one that leverages the new...