DSXchange

Our standards dictate that Jobs are run by Job Sequencers, and Job Sequencers are executed by our standard job scheduling tool. A developer has designed processing where by on Job Sequencer runs several jobs plus a second Job Sequencer. The second Job Sequencer is very simple -- run a Job and check ...

We are migrating from the former Teradata stages to the TD Connector stage. In the TD Muiltload stage , there is a check box " Fail DataStage Job on Error Table rows ." Per pg 155, of i46dectr.pds, Connectivity Guide for Teradata Databases -- Chapter 6. Teradata MultiLoad/TPump/FastExport ...

It's working now! Several things were uninstalled, reinstalled, adjusted, so not completely sure which twist resolved it. Here are the values that are working for us now in IS 8.7 on the Windows 2008 R2 64-bit host. APT_COMPILEOPT=-W/TP -W/EHa -DAPT_USE_ANSI_IOSTREAMS -c -W/Zc:wchar_t- APT_COMPILER=...

ray.wurlod wrote:I have a new 8.7 installation on Windows Server 2008 R2 ... Haven't really begun to look at it yet.

Ray -- Interesting that you have a very similar situation! Any thoughts on the cause or resolution?

Thanks, mobashshar -- that was worth looking at and verifying. We don't see any SDKs in the regular "Program Files" directory, only in the "Program Files (x86)" directory. We double checked and verified that we did select the 64-bit options when we installed Visual Studio C++ 201...

We have now tried VS C++ Premium 64-bit on our Windows Server 2008 R2 Enterprise SP1 64-bit for InfoServer 8.7 and get the same results as before when we try to compile with a transformer. Our LIB, LIBPATH, INCLUDE and PATH env vars all look good as well as the compiler options in the dsparams file ...

mobashshar wrote:I installed IIS 8.7 on XP Pro. VM with MS VC++ 2010 ... working absolutely fine.

Thanks so much -- so good to know it can work!

Is your XP host 32-bit or 64-bit?

What flavor of the compiler is it -- is it the Express Edition?

IBM's 8.7 system requirements indicate that Microsoft Visual C++ 2003/2005/2008/2010 Express Edition are all acceptable.

We just installed 8.7 on Windows Server 2008 R2 Enterprise SP1 and are encountering transformer compile errors, too. We are using Microsoft Visual C++ 2010 Express Edition for the compiler. Looking through this topic I'm not yet seeing how to resolve it, but I do see what information has been reques...

Thanks -- that's the angle I was thinkging of, also. I tried it this morning and verified that it works. Terrific! And I double checked -- our namespace info does not look like it is host specific so I don't expect it to change. If the other details change when we go to production...then someone is ...

We have begun developing jobs to retrieve data via a web service and send it onward. Several are using a web service as a source -- the jobs look like this: Web Services Client stage --> XML Input stage --> onward to a transformer or file or database or wherever I am interested in what others have d...

Any thoughts on whether FASTLOAD or VARTEXT would make a difference?

I had turned unicode on in the column metadata info as I was getting an error about type conversion from string to ustring. When I ran it without the unicode setting on the target columns, it loaded correctly without truncation. Guess there's always more to learn about unicode...

A new Teradata MLOAD parallel job loads one column of a table from a dataset -- the column is of type/size CHAR(11). The TD MLOAD job reads the file, but wants to truncate the data by one character. Everything across the board is CHAR(11). No truncation is needed. The data gets loaded, but is wrong ...

We have our DataStage development standards documented, but audits by the admins are needed to ensure compliance. Audits can be quite time consuming for larger applications. We have a few short cuts, but are looking for something faster and more easily repeatable -- both for ourselves as admins and ...