DSXchange

It implies that your data has less number of columns than those defined in the sequential file stage.

Can you check the column count in both.

When you write in a dataset, the rows will not be organized as it was in the source. Hence you may lose the order.

But if this is ok, you can use stage variables to write sequential numbers and then join on that.

You do not need the last 3 '.000'.

Try substring upto the seconds part.

When you include the jobs in a master sequence, you can pass your sequence parameters through the 'job activity stage' to the sub-jobs called from it.

If you have any problem in doing it, do let us know.

Himanshu, The discussion is only pointed towards people who do not have any experience or expertise and want to gather them from other people who have put their life through the hardship to attain the position. It is not to be read as 'America' vs 'rest of World' or even as 'America' vs 'India'. Bei...

Try resetting the job. It may give you more info.

Some plugins are bought and installed separately ... such as for SAP.

I vaguely remember an Excel ODBC in Unix OS. Search this forum and other search website for this info.

You need a '.000' in the end for milli-seconds.

Locate the stage called 'TRN_INSERT' in the job JpmClsfnIntIndustryHierScheme and verify whether you have the plugin in your new installed version.

Does he belong to the same Unix group as you? Is he a member of dstage group?

You may have to install plugins which are not supplied by default in the server configuration.

You need not do a 'cast'. You can do a select with the datatype in datastage being timestamp.

But can you confirm that the column you try to select is a timestamp.

Both client and server are mutually exclusive till you connect them by logging in.

Did you search the forum.

Check the following post
http://www.dsxchange.com/viewtopic.php? ... ction%3D17

Also check the space in the server.