DSXchange

In the main Transformer editor window itself.

What are you planning on using as the "date" portion of the timestamp you are writing to this DATE field? You will need one, btw.

Discussed ad nauseum here. Search the forums for Convert or EReplace examples using (removing) the @FM character that is tripping you up.

Welcome! :D Are you saying your installation does not have the XML Input, XML Output and XML Transformer stages available? If that's the case, then whomever performed your install chose not to include them for some reason. To solve this, rerun the install script and choose "Install additional plug-i...

When I run the job, the job runs successful, but the data is not shown in the table. Please advice. Not really all that successful then, eh? To me, this implies you are running the job from the Designer and haven't looked at the actual job log from the Director or you would undoubtedly see it chock...

Thanks for posting that for future searchers.

Still waiting for one of these to get a response like - "Thank Gawd! I've been waiting five years for someone to help me with my problem!"

It's all in those individual logs you see from Director. You can use the DSGet* functions from DataStage or dsjob from the command line, search the forums for examples or read the Command Line Interface chapter in the Server Job Developer's Guide.

I know, I had the same question when I read the post... really should have let the OP answer.

Note: If I change the missing column action to "None" in the row splittter stage output format, the job is running very fine, the string is deviding to exacly 3 names and pushing to the output file. My comment is based on your comment highlighted above. When you changed the action to 'none', are al...

Sure, but they're all variations on that theme.

just4geeks wrote:The stage var 'mark' is declared as a timestamp with a default value '12/31/9999' and precision 255.

This says it is a Parallel job, seeing as how stage variables are not typed in Server.

You declared four columns but only seem to have data to populate three, so the fourth column Mark is "missing" if it can't split out data for it. And then you told it to kill itself when that happens.

It is a macro and you can read all about it and all the other macros in the online help.

Not the only way, but certainly the simplest. As noted, just give it whatever name you like, regardless of the original sequential filename, in the FTP stage. You can also use the Telnet capabilities of the stage and the 'Telnet After Command' to rename the landed file. Simplest to just drop it with...

cnu wrote:I am asking about Datetime datatype format in SQL Server. Is it only date or date and time.

Here I am thinking that question really should answer itself.