DSXchange

Hi, You can "simply" use the Hashed file pivot option. Step 1 transform your records so: ID column gets te ID value Data column gets the string "Sev1|": <sev2 column data> : @VM "Sev2|": ... and so on then when you read the Hashed file normalize on the data field and wr...

Hi,
Assumig you are correct and you can't use a parameter as the password
And regardless of that need, I prefer using the command line invocation of the sftp.
That way your allowing easier trouble shooting if and when something goes wrong.

IHTH (I Hope This Helps),

almost forgot... After reading some IBM post regarding the environment variable and realizing that setting it might cause plugin issues later on I decided to use the above mentioned solution.

Hi All, The cause was identified. A usage of a job parameter was made to represent a NullToZero for NullToEmpty values or Null value substitution for columns with the not null constraint. the varchar value wah a space character enclosed with single quotes. We changed the parameter value to double qu...

Hi All, I'm running a parallel job (DS 9.1) getting the following messages in the log: Error occurred during initializeFromArgs(). Unrecognized argument: main_program: Creation of a step finished with status = FAILED. Have gone over the existing 7.5 and 8.5 threads. disabled combination. I see no re...

Thanks Andy
For some strange reason I didn't remember TFS was also an option there

Thanks for the reply Andy
Can you get some info as to the implementation there?
What needs to be configured?
What kind of export / import method they use?
A heads-up on any obstacles would be nice
Thanks in advance,

Hi All,
Is there anyone using TFS (Team Foundation Server) as source control for DataStage jobs?

Where exactly are you trying to do this? If you're trying to use a job parameter, you must select it using the expression editor - for some reason typing it in is not recognized. I'll try it Ray, Thanks. That's true... it doesn't always need to be enclosed as I noted and I forget where it doesn't w...

Hi, Sounds like a corrupt repository or out of sync. In case this is only an issue with this folder, Try exporting all the objects there (in the folder) by selecting them, then delete the folder and import from the export file This should work. By the way, does the nightly backups finish ok? IHTH (I...

Hi All,
(thoght I posted it already )

Is there any way this can work?
Doesn't work in the current site,
was wondering is or should it be possible?

Tested hard coded conversion mask works.

Thanks,

I've done this many a time before with no issues.
Yes Rays they are the same, using save and load.
after the file is created I can view the data from either links.

Just seems like a weird File System issue of some sort.

IMHO,
Yes you went too far.
The whole concept is that everyone has access to it and it alerts you to objects being edited by others.

The only thing you want a final say about, is your production environmemnt,
otherwise you'll be doing nothing else except moving objects around all day.

Goog Luck,

back in the old days (not V1 but V 4.2.1)
I had the ODBC.H in the regular include directory
maybe it was a version fluke

Just thought its important to note in case the one using it is not aware of this.