DSXchange

You'll need an old version of pgp not the new one as it doesn't have the command line. Create a bat file that pgp's the file and as Ray said call that it in an after stage job.

Think chulett is right, I just got the discs last week and they are specifically solaris. The discs are for version 6 btw. I'd get on the phone to them and give em hell.

I agree that your job is way to big, do what ogmios suggests and break it down into smaller jobs. Also when comparing loads into SQL Server and Oracle, SQL Server is pants and Oracle will always beat it. The fact that you have both DS and SQL Server on the same machine is also cause for concern, tha...

I'm trying to access them through designer, I have a sequential stage and I can't look at the data. The message I get is: DATES..Sequential_File_0.DSLink3: DSD.SEQOpen Failed to open Prospects.txt in directory Q:\AUTOMATION\BBCSHOP STATUS = 22. Don't worry about the goat, I have have some chickens a...

Guys, I'm having a big problem trying to access sequential files on different servers. I've looked through the forum and tried everything that has been suggested, this includes: Stating the user in the schedule tab on DS administrator Looked at uvconfig to make sure ALLOWNFS is set to 1 Sacraficing ...

Cheers guys that code works, I was tempted by chulett's suggestion of trimming the timestamp but that would be cheating!!

chulett,

Thanks for your reply, the timestamp is real issue I'm having, I can convert yyyy-mm-dd but I don't know what to do about the timestamp element.

I've looked at the SDK but it only converts to internal and not extrenal.

Hi,

I'm having a problem with dates, I have a date in the format of:

yyyy-mm-dd 00:00:00

I need to convert it into the follwoing format:

dd/mm/yyyy 00:00:00

Can anyone help me?? These date conversions are driving me crazy!!!

Thanks

Willo

Thanks Peter, that works a treat!! :D

Hi,

I have a column that has a comma that I need to seperate, eg the column looks like:

123719,27319

I want to seperate them into 2 seperate columns, I want to this in a transform. Could anyone help please??

Thanks