DSXchange

A bit more information would help in getting people to try to analyze the problem. Is it repeatable in a job (i.e. is the error the same for run of the same job)? Is the "missing" file present at the OS level? If you do a reset of the job after failure do you get a message "from previous run" with s...

I've been programming with DS/Basic since the early 80's in a couple of different flavors and have never seen READSEQ used as a function before. I looked at the docs and didn't see this document, but did write a little test program and was pretty surprised when it worked, i.e. the WHILE took "ReadSe...

Kumar - I just logged in to a DS site. The "NAME" column in hashed file DS_JOBOBJECTS is a Dictionary entry - but it doesn't contain the NAME of the job, just the name of the object in question and is therefore unaffected by a job name change in DS_JOBS.

If you place a sequential file stage between your UV and transformer that uses named pipes (or perhaps just an IPC stage) does the job work? Does your job's control information specify any particular buffering (project default, inter-process or in-process?) If it is set to "project default" then are...

No problem, roceller - we all have opinions and I, too, was just expressing my view. At least this site doesn't have those horrendous pop-ups and even pop-unders that other so-called "technical" or "expert" sites have. And even after paying a membership fee the pages are so riddled with advertisemen...

Kumar - only those columns with type "D" are actually in the data portion of a file. "I"-types are joins to other hashed files. The NAME of a job is only found in the DS_JOBS file as both Ray and I have been saying.

There is no ON.ERROR clause in your READSEQ (and you said there was!)and the loop condition is odd (I've never seen READSEQ used as a function. I think your loop should be changed to something like: Finis = 0 ReadSeq vNomParam From VFichierIni Else Finis = 1 ReadSeq vValParam From VFichierIni Else F...

The issue does sound like a corrupt index that needs to be fixed in the DS.TOOLS menu called from the ADMINistrator or TCL when no other users are logged in.

Ray - thanks for pointing that out, I saw hashed files and assumed that we were in the Server world and answered the question as posted (knowing that the answer wasn't going to help, since knowing which stages to use to query a database doesn't give you the tables required or the layout of columns i...

You are seeing 2 issues: Less data is being written than you expect. Does your job monitor or Designer show the correct number of rows being read from the hashed file? In that case your constraint(s) must be filtering out the rows and perhaps you might post that part of your job. If the "wrong" numb...

You use the Hashed file stage to access the Db directly, and you can access via ODBC with the dsn "localuv"

Check in your control panel applet for Ascential DataStage to see if all the services are running.

If you write a job or script to parse the dsx you can look for a line "BEGIN DSJOB" and then the next line will be ' Identifier "{JobName}"', which you can change to the new name. The category information is found a bit further down in a line looking like ' CATEGORY "CatName"'. I prefer DS/Basic, bu...

Initializing the array using MAT will remove your warnings, but it probably won't help you in that the array will have empty or other values instead of the expected correct ones. I still think that the cause lies in the routine which reads the parameter files - it looks like the only entity in your ...

The only official way to do this is by using the rename functionality in the director/manager/designer to rename jobs on a one-by-one basis. A job's metadata is stored in several files, but the DS_JOBS is the only one which stores the name (as a field), all other references to the job in the other h...